Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Retrieving results from PL/SQL using ODBC
I'm writing an application in Visual C++ 1.52 (clients still want 16-bit apps!) using ODBC. What I'm trying to do is execute a piece of PL/SQL from the C++ app (not a stored procedure) and retrieve the results. The user basically types in the PL/SQL into a TextArea and the application calls CRecordset::ExecuteSQL(). Executing the PL/SQL is no problem. How do you get the results back without using a temporary table???
Any replies will be greatly appreciated. Please can you express any solution using an example. Thanks again.
--- Graeme Humphrey Aberdeen, UKReceived on Tue Jul 07 1998 - 00:00:00 CDT