Re: Access97 ODBC and Stored Procedures

FYI for anyone who cares.

I was able to get call a stored procedure (function) exercising return values, in , in out and out parameters using the syntax..

{? = call [procedure_name](?,?,?,?)}

The kicker was the procedure/function name MUST be in all caps. Who woulda thunk?

ChemWare, Inc. wrote in message <7ikaq5$hsa$1_at_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 - 17:14:06 CDT