Executing PL/SQL in Excel

[scos00]

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

 

[Tim Williams]

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

 

[scos00]

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]

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]

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.