Re: ODBC and stored procedures

In article <3tcamm$2i9$1_at_mhadf.production.compuserve.com> Jo Coutuer <100414.1243_at_CompuServe.COM> writes:
>From: Jo Coutuer <100414.1243_at_CompuServe.COM>
>Subject: ODBC and stored procedures
>Date: 4 Jul 1995 21:09:42 GMT
 

>I would like to find out how calling a stored procedure is
>possible with an Oracle 7.1 database attached through ODBC.

snip
>Thanks..
 

>--
>Jo Coutuer

You must create a pass through query in your ODBC enabled application (I'm assuming VB or Access). Your application documentation should give examples for creating a pass through query.

Once you have the pass through created, set the sql string property in one of the following ways:
1) begin execute my_procedure(arg1, arg2) end; or
2) {call my_procedure(arg1, arg2)}

Then execute the query.

It is important to note that you cannot get results back from a stored procedure. That is, if arg1 and arg2 are modified, the results will not be passed through to the odbc application. This is an Oracle ODBC driver limitation.

To get results back, you can insert them into a "results" table and then query the table.

HTH
Andy
Andrew McAllister -- mcallister_at_grad.missouri.edu Office of Research, University of Missouri-Columbia The views above are my own, and NOT those of my employer. Received on Wed Jul 05 1995 - 00:00:00 CEST