RE: [toad] Can I use TOAD with "automation" from VBA?
- 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.
Infineum International Ltd.
Work: +44 (0)1189 317432
Fax: +44 (0)1189 317493
Mobile: +44 (0)7770 770558
Sent: Monday, 30 April 2001 18:53
Subject: [toad] Can I use TOAD with "automation" from
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
procedures and functions for my QA testing group. I'm using
the "middleman" to do this, and looking for opinions on how
improve my process.
Currently, this is how I'm testing our packages, but I know
more efficent way to do this. ( FWIW, it works great, but
is a bit
Lets' say I'm testing
1. I've set up an excel spreadsheet holding the
want call/test that procedure with. Excel "column A" holds
the "param1" values, column B holds the "param2" values.
in the spreadsheet represents a single call
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
the results of the call.
3. Winrunner then pastes the PL/SQL script into TOAD
it, giving me my test results back through the DBMS_output.
4. Winrunner then grabs the DBMS_output result from
writes it back into Excel on the corrrect row ( basic easy
sure, but it works fine)
The problem with this is that I am using 3 applications
Winrunner, & TOAD) to do this realtively simple process. (
winrunner costs almost $1000 a license.)
What I want to do is use only TOAD and Excel. (if possible,
excel!) So my question is: can i set up TOAD as an
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
for an hour or so.
My biggest issue is that i need to be able to "send"
toad from Excel (easy), AND "return" the results from the
back into Excel (hard).
I had envisioned setting this process up as a Macro in Excel
QA testers could just "push a button" and run some package
Then they could change some of the paramters in the
and "push the button" again, giving them lots of "what
scenarios. Also, if changes were made to the package
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
approach that is simple AND reliable? Any Ideas?
something similar, and want to point me in the better
QAA GERS Reatil Systems
To unsubscribe, send email to firstname.lastname@example.org
or go to http://www.egroups.com/list/toad, and click
Your use of Yahoo! Groups is subject to