Re: Oracle ODBC and MS Access

Try coding the pass-through as a PL/SQL block;

Begin
  MyProc;
End;

The above is what SQL*Plus does whenever you issue the "execute" command. By the way, do not put the "/" after the end like you normally would when trying to execute a PL/SQL block in SQL*Plus

I tested the solution above; but, I was using Access 97, not Access 95. I used Oracle's ODBC driver Oracle73 2.5 (2.05.0301) against the Scott schema in a 7.3.3 database to invoke a procedure that inserts a row into the DEPT table. No problem.

Hope this helps.

Larry G. Elkins
elkinsl_at_flash.net

"S Metro" <smetro_at_nospam.world.std.com> wrote:

>I am trying to use a pass-through query to call a stored procedure in Oracle
>7.3 and am having no luck. Does anyone know the syntax for calling an
>Oracle stored procedure from MS Access 95 in a pass-through using ODBC?
>
>Normally I would use "execute myproc." This isn't working in MS Access.
>
>Any help is greatly appreciated!
>S. Metro
>smetro_at_world.std.com
>(Take out nospam if replying via email)
>
>
>
Received on Tue Dec 09 1997 - 00:00:00 CET