Returns result sets through ODBC from a stored procedure

From: Lucian Cristache <lucian_at_vtcinet.com>
Date: Sun, 7 Feb 1999 20:09:45 -0800
Message-ID: <Crtv2.2498$1a1.59700@newsfeed.slurp.net>

I have to convert a SQLServer database into Oracle 8. Stored procedures from SQLServer can return result sets but the same thing is not possible with Oracle. With Oracle a cursor variable could be used for this purpose. The client of my application is implemented in VC++ with MFC and uses the ODBC to connect to the database.

Can I use a cursor variable in my client program that allows me result sets simulation ?
I tried that but I didn't succed ! My guess is that it is not possible.

Have anybody some ideas about how can I retrieve result sets through ODBC from a stored procedure ?

Any help will be appreciated.

Lucian Received on Sun Feb 07 1999 - 22:09:45 CST