Oracle Stored Procedure via Pass-through?

[CptCrusty1]

Is it possible to run an Oracle STored Procedure from Access?

I live to work and I work to live.

 

[dhookom]

You can create pass-through queries in Access that bypass JET and act directly on the remote server.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CptCrusty1]

Thanks Dhookom... I write pass-throughs all the time, however, I want to execute a stored procedure the same way. In oracle, I would call it in a package, or another store procedure. My procedure is called sp_TEST, and the language to call it would be:

begin

sp_TEST;

END;

However, if this is in a pass-through query, the query fails. I'd like the user to be able to run the sp as they don't have access to my Oracle tools.

I live to work and I work to live.

 

[PHV]

Have you tried to play with an ADODB.Command object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CptCrusty1]

NOt yet. I'll give it a shot tho...

I live to work and I work to live.

 

[smartyme]

I have not try to run an oracle PL/SQL from MS Access pass through query before but to execute a MSSQL store procedure, use the Execute commant in the pass through query. Try Execute sp_TEST