Oracle PL/SQL calls via MS Access Pass-Through Query

[iansoady]

I am using a MS Access 2000 DB as a front end to an Oracle v8i database. I want to invoke PL/SQL stored procedures and believe that this is achievable through pass-through queries but can't find any documentation on this - merely executing the query doesn't work. Any helpful suggestions?

 

[oharab]

You need to create a new query, then paste the SQL into it, then in the Query menu choose SQL specific->Pass Through.

hth

Ben ----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------

 

[Blanch]

I believe the PL/SQL command is the same as Transact-SQL:

try...

exec procedure name

within the body of the stored procedure. I will look it up and correct myself if I am wrong.

Jim