From: "Daniel Clamage" Subject: Re: Retrieving results from PL/SQL using ODBC Date: 1998/07/07 Message-ID: <01bda9f3$3fa2e8b0$6f29c9cd@saturn>#1/1 X-NNTP-Posting-Host: d12-47.dyn.telerama.com References: <35a1dcd4.0@newsread1.dircon.co.uk> X-Complaints-To: newsabuse@supernews.com X-Trace: 899867760 BPIPSDRGT2CD2CCABC usenet76.supernews.com Organization: Telerama Public Access Internet (http://www.telerama.com) Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools 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 wrote in article <35a1dcd4.0@newsread1.dircon.co.uk>... > 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 > > >