Re: Initiating Oracle stored procedures through ODBC

[snip]
> The problem is that we can't get any information back from the procedure, not
> even an exit status to indicate whether it has executed successfully.
>
> Does anyone know how we can get either IN/OUT parameter values or the return
> code from PL/SQL functions from within VB? Using a message table is always an
> option, but it just seems so kludgey.

From Oracle support bulletin 10052651.6 (according to my notes)

with respect to calling stored procedures:

"..out parameters are supported only at ODBC level 2 conformance, since our driver is level 1 compliant, this is not supported. Return values or dynasets are also not supported by the Oracle Driver Refer to Microsoft KB article number Q120491 for more information on this."

Regards Geoff Ingram. Received on Wed Apr 17 1996 - 00:00:00 CEST