Re: Initiating Oracle stored procedures through ODBC

From: Sol Shapiro <shapiro_at_pathcom.com>
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

Original text of this message