Loading ...
Sorry, an error occurred while loading the content.

RE: [toad] Can I use TOAD with "automation" from VBA?

Expand Messages
  • Davison, Kevin
    If you don t want to use Oracle OLE objects, a simpler approach could be to create a results table based on run ID (or some other key). Have a run ID parameter
    Message 1 of 3 , May 1, 2001
    • 0 Attachment
      If you don't want to use Oracle OLE objects, a simpler approach could be to
      create a results table based on run ID (or some other key). Have a run ID
      parameter based external data link to pull the results, and a small VBA to
      organise it all.

      Cheers

      Kevin Davison
      Corporate Applications
      Infineum International Ltd.
      Work: +44 (0)1189 317432
      Fax: +44 (0)1189 317493
      Mobile: +44 (0)7770 770558


      -----Original Message-----
      From: dalemotsiff@...
      [mailto:dalemotsiff@...]
      Sent: Monday, 30 April 2001 18:53
      To: toad@yahoogroups.com
      Subject: [toad] Can I use TOAD with "automation" from
      VBA?

      hi fellow Toadies,

      Slightly OT TOAD question (if that's not an oxymoron):

      I'm trying to set up a PL/SQL "package" testing tool to call
      various
      procedures and functions for my QA testing group. I'm using
      TOAD as
      the "middleman" to do this, and looking for opinions on how
      to
      improve my process.

      Currently, this is how I'm testing our packages, but I know
      there's a
      more efficent way to do this. ( FWIW, it works great, but
      is a bit
      cumbersome)

      Lets' say I'm testing
      "this_package.procedure_A(param1,param2)":

      1. I've set up an excel spreadsheet holding the
      parameters I
      want call/test that procedure with. Excel "column A" holds
      all
      the "param1" values, column B holds the "param2" values.
      Each row
      in the spreadsheet represents a single call
      to "this_package.procedure_A(param1,param2)"

      2. I then use Winrunner ( an automated software
      testing tool )
      to grab the parameters out of excel and dynamically merge
      them into a
      short PLSQL script. This script just
      calls "this_package.procedure_A", and generates a
      DBMS_output with
      the results of the call.

      3. Winrunner then pastes the PL/SQL script into TOAD
      and runs
      it, giving me my test results back through the DBMS_output.


      4. Winrunner then grabs the DBMS_output result from
      TOAD and
      writes it back into Excel on the corrrect row ( basic easy
      stuff, for
      sure, but it works fine)


      The problem with this is that I am using 3 applications
      (excel,
      Winrunner, & TOAD) to do this realtively simple process. (
      and
      winrunner costs almost $1000 a license.)

      What I want to do is use only TOAD and Excel. (if possible,
      just
      excel!) So my question is: can i set up TOAD as an
      "automation
      server" from Excel VBA?. i.e:

      Dim objTOAD As Object
      Set objTOAD = CreateObject("TOAD.Application")
      manipulate.TOAD.to.my.heartsContent.here = "happy.me!"
      Set objTOAD = Nothing

      I pretty sure this CAN'T be done, having looked over the
      quest site
      for an hour or so.

      My biggest issue is that i need to be able to "send"
      keystrokes to
      toad from Excel (easy), AND "return" the results from the
      DBMS_output
      back into Excel (hard).

      I had envisioned setting this process up as a Macro in Excel
      so that
      QA testers could just "push a button" and run some package
      tests.
      Then they could change some of the paramters in the
      spreadsheet
      and "push the button" again, giving them lots of "what
      if..."
      scenarios. Also, if changes were made to the package
      down the
      road, the testers would just re-open the tests and re-run
      them at any
      time --- sort of a dynamic test environment for them.

      So, my question is, can anyone think of an alternative to my
      current
      approach that is simple AND reliable? Any Ideas?
      Anyone doing
      something similar, and want to point me in the better
      direction?

      Thanks
      Dale Motsiff
      QAA GERS Reatil Systems








      To unsubscribe, send email to toad-unsubscribe@egroups.com
      or go to http://www.egroups.com/list/toad, and click
      "Unsubscribe".

      Your use of Yahoo! Groups is subject to
      http://docs.yahoo.com/info/terms/
    Your message has been successfully submitted and would be delivered to recipients shortly.