Re: Initiating Oracle stored procedures through ODBC
Date: 1996/04/24
Message-ID: <4lk4f8$3jl_at_news.pathcom.com>#1/1
mudhens_at_cyberramp.net (richard castorena) wrote:
>I am currently using MS Access 2.0 to access a Oracle 7.1 database
>using ODBC. I would like to be able to initiate an Oracle stored
>procedure from Access. The only thing I can think of is to use a SQL
>pass-through query to kick it off.
>I have tried sending "exec procedure_name" but it always returns
>invalid SQL statement. I guess it is expecting something using a
>Select clause. BTW, I have successfully created other pass-through
>queries so there isn't a problem with the connecting to Oracle.
>Any help would be appreciated. Please e-mail me at
>mudhens_at_cyberrramp.net
>Thanks, Richard Castorena
Design (Query Tab)
Under Query Menu get to SQL SPecific Bar
Use Pass-Through Query
Works every time. (Help on PAss Through Query is quite specific on this).
Sol. Received on Wed Apr 24 1996 - 00:00:00 CEST