Re: How to retrieve data from plsql stored proc or function using MFC ODBC

How about make your Procs returning the rows in an array ? Your front-end can then process the array elements.

okant_at_yahoo.com wrote in message <74lhsl$mt5$1_at_nnrp1.dejanews.com>...
>We are developing an application which will retrieve data from an ORACLE7
>database and we decided to use stored procedures and functions beacuse of
>simplicity. We use MFC/C++ at frontend.
>
>We can call stored procedures using CRecordset::ExecuteSql() but this
 doesn't
>returnm any value back to ODBC. We couldn't yet find a way to return any
 value
>from stored proc/func back to ODBC application.
>
>Can anybody give an advise?
>
>Thanks
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Dec 10 1998 - 00:00:00 CST