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

--
Tim Williams
Palo Alto, CA


"scos00" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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.