Re: Access97 ODBC and Stored Procedures

From: ChemWare, Inc. <chemware_at_interserv.com>
Date: Thu, 27 May 1999 16:44:48 -0400
Message-ID: <7ikaq5$hsa$1@nntp5.atl.mindspring.net>

I was able to get this code to work once for a technology demonstration. I was using the syntax...

{? = call [procedure_name]()}

I do not recall if I was using Access 7 or 97 or if I was using Oracle drivers or Intersolv drivers. I can not figure out why it's not working now. It could be an Oracle version problem. I'm using 7.3.4 now but it could have been originally 7.3.2 when I was successful.

---

strSQL2 = "{? = call TestingStoredProcedures()}" Set qdf2 = cnn.CreateQueryDef("TestingName", strSQL2) With qdf2
' Declare parameters for stored procedure

    .Parameters(0).Direction = dbParamInput End With

Set rst2 = qdf2.OpenRecordset()

Debug.Print qdf2..Parameters(0)

Set rst2 = Nothing
Set qdf2 = Nothing
================================================

Chris Weiss wrote in message <7ik4lb$efd$1_at_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 - 15:44:48 CDT