Re: PL/SQL & C++

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 Received on Thu Jan 28 1999 - 12:18:36 CST