Re: Urgent : OCI Gurus : Please Help . . .

From your config file, generate an SQL statement reading: BEGIN
        PROCEDURE_A( :1, :2, :3);
END;
open a cursor, parse the statement as with any regular select statement. Use obndrv to bind the variables to their values.

Regards,

        Alain         

szhan_at_csclub.uwaterloo.ca a écrit dans l'article <7mfhns$jpp$1_at_nnrp1.deja.com>...
> Hi, Did you received any tips yet? I am a newbie and I have
> the same question. If you solved the problem, can you share
> the solution with me?
>
>
> philip
> szhan_at_csclub.uwaterloo.ca
>
>
>
>
> In article <7luoiu$h90_at_dfw-ixnews9.ix.netcom.com>,
> "tanksali" <tanksali_at_ix.netcom.com> wrote:
> > Hi,
> >
> > I am trying to write a C++ program which reads the following at run
> time
> > (from a config file)
> >
> > 1> Stored procedure name.
> > 2> Arg 1, Arg 2 . . .
> > 3> Val 1, Val 2 . . .
> >
> > The types of the arguments and their values will all be known only at
> run
> > time.
> > My program needs to fire the stored procedure with the given arguments
> > against the underlying Oracle database using OCI 7.3 calls and return
> the
> > results.
> >
> > The main problems that I am facing are with respect to the dynamic
> binding
> > of the variables.
> > Also obndra does not allow bind by position.
> >
> > Any help or ideas on how I can make my program fire the stored
> procedure
> > given at run time with the arguments provided will be enormously
> > appreciated.
> >
> > Thanks in advance.
> > Shashank
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>
Received on Fri Jul 16 1999 - 15:43:59 CDT