Re: Packages vs PRO*C/C++

You can call a shell script which executes a stored procedure via sqlplus command avoiding Pro*C++.
Branko

dmcclory_at_my-dejanews.com wrote:

> David, so far as I know, the only way to call a package from within C++ is to
> use Pro*C/C++. If you know the proper things to set up in your compiler
> environment, then it's just a simple matter of inserting a normal looking set
> of PL/SQL code to call the package.
>
> You can also call C++ functions from within an Oracle package, though that's
> more difficult. You have to compile the C++ code into a DLL or library, then
> notify the database of the library, and set up a "wrapper" package to do the
> calls.
>
> In article <357D466B.45BAA95E_at_tid.es>,
> David Labajo <labajo_at_tid.es> wrote:
> >
> > Hello,
> >
> > I'm developing an application which connects to an Oracle database using
> > PRO*C/C++. The application is written in C++ under Solaris 2.5.1. The
> > application works right, but I have had a lot of problems with PRO*C.
> > It's not Multithreaded safe, and it has a lot of memory leaks. I have
> > finally solved all these problems, but I think there should be something
> > more eficient than PRO*C.
> >
> > I've just read there are something called "Packages", stored in the
> > server like PL/SQL, and that can be accesed from C++ programs; bu HOW?.
> > How can I write a package and use it from a C++ program?. Do I have to
> > connect to the database like in PRO*C?. Do I have to compile/link my
> > program with special libraries?......
> >
> > The question is: Which is the best way to make selects, inserts,
> > updates, deletes in an Oracle database from a c++ program? If PRO*C is
> > the answer, Is it better to use classes made with dynamic SQL (Method 4)
> > to perform all the SQL sentences (This is what I've done till now); or
> > explicit SQL sentences without dynamic SQL?.
> >
> > Thanks in advanced for your answer
> >
> > David Labajo
> > TID
> >
> > labajo_at_tid.es
> >
> >
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu Jun 18 1998 - 19:56:16 CEST