Retrieving results from PL/SQL using ODBC

From: Graeme Humphrey <graeme.humphrey_at_prosoftres.co.uk>
Date: 1998/07/07
Message-ID: <35a1dcd4.0@newsread1.dircon.co.uk>#1/1

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, UK

Received on Tue Jul 07 1998 - 00:00:00 CDT