Re: PL/SQL & C++

A quick update: The problem with returning large numbers of rows was not the fault of the OTL classes, but my mishandling of null values from Oracle.

I reworked my code to test for null values with the built in test for null (is_null()), and all is well.

turnip1 at net-gate com

In article <78q9lh$kid$1_at_nnrp1.dejanews.com>,   turnipcyber_at_my-dejanews.com wrote:
> I am currently using the OTL classes. It has allowed me to use the compiler I
> was told to use(VC++5.0), and keep the code portable between NT and Unix.
>
> OTL supports PL/SQL like statements. It allows you to insert values into the
> SQL statement through streams as well as get back results through streams.
>
> I have encountered one problem involving returning large amounts of data (+30k
> rows), but I have a work around.
>
> Check out: http://home.sprynet.com/sprynet/skuchin. Sergei Kuchin wrote it,
> and you get get to the OTL page from there. All you need to run OTL is
> availible there, it's just one (big) header file.
>
> It seemes to run faster than the ODBC I had been using before and was a breeze
> to get working. I'd pay double what I payed for it. :)
>
> If you have any question email me at:
> turnip1 at net-gate com
>
> In article <77ujnf$1ni$1_at_remarQ.com>,
> "Daniel Clamage" <dclamageNOSPAM_at_telerama.com> wrote:
> > You can embed PL/SQL in C quite easily without having to resort to OCI, by
> > using Pro*C. Instead of the keywords EXEC SQL, you use EXEC SQL BEGIN. Check
> > the Oracle documentation for Pro*C. It's online at
> > http://technet.oracle.com.
> >
> > --
> > - Dan Clamage
> > http://www.telerama.com/~dclamage
> > If you haven't crashed the Server,
> > you haven't been trying hard enough.
> > Michael Krolewski wrote in message <36A23A7F.AC1F76E4_at_u.washington.edu>...
> > >You can use the OCI functions --- a bit cumbersome -- or OTL a C++ library
> > that
> > >someone (who?) has to reduce some of the overhead and add streams.
> > >
> > >Assuming the stored procedure exists in your database you can create a
> > parsed
> > >startment like
> > >
> > >char someParsed[] = "begin\n"
> > > " thatStoredProcedure( arg1, arg2,
> > arg3 );
> > > "end;";
> > >
> > >Using the appropriate functions, you can get IN OUT parameters or returned
> > >values.
> > >
> > >Mike Krolewski.
> > >
> > >amerar_at_theocc.com wrote:
> > >
> > >> Hello,
> > >>
> > >> Can anyone tell me the utility I need to preprocess embedded PL/SQL that
> > is
> > >> within a C or C++ program?
> > >>
> > >> Please send responses to e-mail.
> > >>
> > >> Thanks,
> > >>
> > >> Arthur
> > >> amerar_at_theocc.com
> > >>
> > >> -----------== Posted via Deja News, The Discussion Network ==----------
> > >> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> > >
> > >
> > >
> >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 05 1999 - 13:23:17 CST