RE: Calling Stored Procedures from MS Access or C++
Date: 1996/05/26
Message-ID: <4oam6u$rig_at_lal.interserv.net>#1/1
> 777sys_at_boeing.com (Stephen_Y_Smith) writes:
> How do you call an Oracle 7.2 stored procedure from Microsoft Access or
> from Visual C++? Please include specifications on how to pass
> parameters and retrieve an answer set (recordset).
>>>>
Here's an example of the interoperable ODBC SQL syntax for calling stored procedures (page 537, Windows Multi-DBMS Programming, John Wiley & Sons, ISBN 0471-01676-4) where 50 is a parameter:
{call sp_bycatg (50)}
It is the same for Visual C++, VB, Access or whatever. However, if you are using it with Access or VB using Data Access Objects then you need to set it up as an SQL passthrough query (DB_SQLPASSTHROUGH, page 521).
BTW, for Oracle stored procedures do not return a result set.
Ken North
author: Windows Multi-DBMS Programming
Resource Group, Inc.
2604B El Camino Real, #351
Carlsbad, CA 92008-1214
FAX: 619-729-5127
e-mail: kennorth_at_interserv.com or 71301.1306_at_compuserve.com
Received on Sun May 26 1996 - 00:00:00 CEST