Re: MS-ACCESS calling stored procedure

From: Sreeni Karpurapu <karpurapus_at_detroitedison.com>
Date: 1997/08/20
Message-ID: <01bcada9$6dad8d60$185909a2@karpurapus.deco.com>#1/1

You cannot call functions or stored procedures with in/out or out parameters.
How ever you can call a stored procedure with "IN" parameters. You need to use a passthrough query option to execute your stored procedure.

If you need some data back to your MS Access program, you need to insert that data into a temporary work table through your stored procedure and then Select the data from that temporary work table.

For Example

tempstr = "Begin Proc1( '" & StrVar1 & "' , '" & StrVar1 & "' , '" & StrVar1 & "'); End;"
mydb.Execute tempsql, dbSQLPassThrough

In the above code Proc1 is a stored procedure

Hope this is helpful

Sreeni

Simon Maufe <maufe_at_daugherty.com> wrote in article <01bcad22$2baa36c0$26dd90a4_at_SNMAUF.MONSANTO.COM>...
> how do I code an MS ACCESS module to call an Oracle Stored Procedure? I
> will have already conected to the Oracle database via Oracle's 2.0 ODBC
> driver. If this was a function I could use SELECT function from DUAL, but
> it's a procedure with in/out variables.
>
> Thanks ! Simon
> --
> Any comments or statements made are not necessarily those of Monsanto
> Corporation, its subsidaries or affiliates.
>
>
Received on Wed Aug 20 1997 - 00:00:00 CDT