Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Retrieving results from PL/SQL using ODBC
You can embed PL/SQL anonymous blocks, as well as SQL, in C or C++ programs, using the Oracle Pro*C precompiler. If you go to http://technet.oracle.com and sign up for their free technical service, you'll get access to ALL of their documentation, including the Pro*C precompiler and OCI manual. This is a very good resource and it's free.
-- - Dan Clamage http://www.telerama.com/~dclamage If you haven't crashed the Server, you haven't been trying hard enough. Graeme Humphrey <graeme.humphrey_at_prosoftres.co.uk> wrote in article <35a1dcd4.0_at_newsread1.dircon.co.uk>...Received on Tue Jul 07 1998 - 00:00:00 CDT
> 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
>
>
>