Re: Access97 ODBC and Stored Procedures

From: Chris Weiss <weisschr_at_pilot.msu.edu>
Date: Thu, 27 May 1999 14:58:38 -0400
Message-ID: <7ik4lb$efd$1@msunews.cl.msu.edu>

Access uses stored procedures and functions poorly, depending on the version..

What I would recommend is writing a wrapper procedure that will make the call you want and write the results to a table that Access can read. You might have to fiddle with the ODBC settings to get a stored procedure call to work. I would recommend setting your SQL to pass through within Access and then reading an intermediate table for the variable results from the base function/procedure.

You might have to use an anonymous block for your call to the stored procedure:

Begin
mycall;
end;

Hope this helps.

Christopher Weiss
Professional Services Division
Compuware Corporation

ChemWare, Inc. <chemware_at_interserv.com> wrote in message news:7ik2pf$qhl$1_at_nntp8.atl.mindspring.net...
> I need to call Oracle stored procedures,functions and packaged procedures
> from Access applications. I also need to evaluate the return values and
> in/out parameters. I have found little documentation on how to do this
using
> ODBCDirect. I can't get it to work.
>
> Any help would be appreciated.
>
>
Received on Thu May 27 1999 - 13:58:38 CDT