Re: ODBC, stored proc, cursor return type

Mary Walker wrote in message <34C777B1.3284B316_at_kenan.com>...
>I am using the Oracle ODBC driver. In my C++ code, I can bind a stored
>procedures output, call the stored procedure and get the correct
>answer. But only if the return type is in the SQLBindParameter data
>type list. This is a problem if the stored procedure returns a cursor
>variable.
>
>If anyone has any experience calling a stored procedure that returns a
>cursor, from C/C++ code, through ODBC, I would appreciate any hints. I
>am used to the following syntax for a stored procedure that returns an
>integer. I was trying the same ODBC calls but with a fetch for a stored
>procedure that returns a cursor variable.

Supposedly the Microsoft ODBC Driver for Oracle allos you to do this.

The problem is that there is not an "ODBC" way to do this without breaking the rules in some manner.

Using Oracle, this is easy to do with OCI in C or C++, but not with ODBC...

I hope this helps,

Robert Clevenger Received on Mon Jan 26 1998 - 00:00:00 CET