Executing PL/SQL in Excel
 

Hi,
Anyone know if it is possible to execute Oracle PL/SQL code from within
Excel VBA code?
Thanks.


--
scos00
------------------------------------------------------------------------
scos00's Profile: http://www.excelforum.com/member.php...o&userid=28264
View this thread: http://www.excelforum.com/showthread...hreadid=491805

Executing PL/SQL in Excel
 

Use ADO.
Create an ADO.Connection, connect to your Oracle database and use
Connection.Execute strPLSQL

Does your code return any records or values? Does it take any parameters?

Tim

--
Tim Williams
Palo Alto, CA


"scos00" wrote in
message ...

Hi,
Anyone know if it is possible to execute Oracle PL/SQL code from within
Excel VBA code?
Thanks.


--
scos00
------------------------------------------------------------------------
scos00's Profile:
http://www.excelforum.com/member.php...o&userid=28264
View this thread: http://www.excelforum.com/showthread...hreadid=491805

Executing PL/SQL in Excel
 

So it is possible? That's great if I can get it working it will do
exactly what I want.

Yes I will need to pass 1 parameter to the stored procedure and then
capture a set of records later but this won't be in the return value.
What I want to do is pass the parameter to a procedure/function, then
the function will create records in a table. Then I want to read the
data from the table and drop it into a worksheet. I have used the ADO
connection before so I will try to dig out the syntax now....

Thanks!


--
scos00
------------------------------------------------------------------------
scos00's Profile: http://www.excelforum.com/member.php...o&userid=28264
View this thread: http://www.excelforum.com/showthread...hreadid=491805

Executing PL/SQL in Excel
 

GREAT! Got it working with a simple procedure. Now I need to see if I
can get it working with a function - how do I capture the return
value??


--
scos00
------------------------------------------------------------------------
scos00's Profile: http://www.excelforum.com/member.php...o&userid=28264
View this thread: http://www.excelforum.com/showthread...hreadid=491805

Executing PL/SQL in Excel
 

Right, I created a wrapper procedure to call the DB function so I don't
need to capture the return value (may add this later if someone can
help me out).

The only problem I have left now is that after executing the procedure
and fetching the data into the worksheet I lose focus from Excel
completely and have to manually select it from the Windows toolbar -
bizarre??! any ideas?

Thanks.


--
scos00
------------------------------------------------------------------------
scos00's Profile: http://www.excelforum.com/member.php...o&userid=28264
View this thread: http://www.excelforum.com/showthread...hreadid=491805