Re: calling stored procedure from MS ACCESS

This should get you started in the right direction.

I usually code an access query as a block of pl/sql and mark it as a passthrough query like this

declare
 ...
begin
  ...
  do some stuff
  ...
end ;

this allows you to call the procedure, declare some cursors, etc.

as far as getting some values back from Oracle and inter acting with access, good luck

On 12 Sep 1997 01:36:08 GMT, "Simon Maufe" <maufe_at_daugherty.NOJUNK.com> wrote:

>
>I'm a DBA and not a programmer, and need an example of calling an Oracle
>stored procedure from Microsoft Access 97 or 7 or 2! Ideally the example
>will include parameters and I'll be in heaven if it included in/out
>parameters!
>
>Thanks ! Simon
Received on Fri Sep 12 1997 - 00:00:00 CEST