Re: Calling Stored Procedures from Access 97

If you are using the Microsoft ODBC driver for Oracle (v2.73) try creating a pass through
query using the following syntax

{call proc()}

where proc is the name of the procedure (may need to stick owner in front). If you
are using a different driver the syntax may be different (see the help file for the driver
which is usually available when you setup a connection in the ODBC Administrator).

 Al

Stefan Jahnke <sjahnke_at_tkc.de> wrote in message news:36471813.C9098CE_at_tkc.de...
>Hi,
>
>I have a bunch of stored procedures in an Oracle 7.3 database. Now I
>have to call them directly from Access 97. How does this work ? I tried
>to rewrite some procedures as functions and call the function from a
>view, then select the view from Access (really not a convenient
>solution).Additionally, it won't work for most of the procedures,
>because data is being updated, so I couldn't call them from a view.
>Besides this, I tried SQL-Pass-Through, but it doesn't support EXECUTE,
>afaik.
>
>HELP !?!?
>
>TIA
>Stefan
Received on Tue Nov 10 1998 - 00:00:00 CST