Re: How to call an Oracle 10g stored procedure from C++

"Amit" <amitdedhia_at_yahoo.com> wrote in message news:1134798216.794458.269270_at_g49g2000cwa.googlegroups.com...
> Thanks very much hpuxrac..the site is really useful..
>
> I have one more question...how to call PL/SQL procedures from C++?
>
> Best regards
> Amit Dedhia
>
> hpuxrac wrote:
>
> > Amit wrote:
> > > Hi
> > >
> > > I am totally new to Oracle. I have a very simple question. I have a
> > > legacy application written in C++ and using Oracle RDB (on
ALPHA/VMS).
> > > The backend is changed from Oracle RDB to Oracle 10g (on ALPHA/VMS). I
> > > want to know how to call Oracle 10g Stored procedures from C++?
> > >
> > > I dont yet know which C++ compiler is being used. Can any one tell how
> > > is it done in popular C++ compilers like Borland?
> >
> > I don't think you will find a Borland compiler on VMS.
> >
> > The OCI interface is what most c programs use.
> >
> > Check out the documentation at tahiti.oracle.com ...
> >
> > Oracle supplies sample programs as part of the installation process.
> >
> > >
> > > Thanks in advance
> > >
> >
> > Have fun!

You can use OCI or there is a C++ interface (I think OCI++). Usually you define the bind variables, set them, and set the statement and execute it. When you install the Oracle client they have a whole directory of examples for C and C++ using oci. I would look at those. Jim
>
Received on Fri Dec 16 2005 - 23:49:05 CST