Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Return PLSQL variable value to OCI

Re: Return PLSQL variable value to OCI

From: Gert Rijs <nospampleasegem_at_wirehub.nl>
Date: 1997/10/14
Message-ID: <01bcd8be$982308f0$9f1b56c3@gertrijs>#1/1

use
  char *SQL = "BEGIN MyPackage.GetVersion(:version); END;"; (note the :version)
and then obndrv an integer to :version

hth,
gert

-- 
reply address is altered to keep the spam down
remove the nospamplease part to reply...

Edward Baggott <eabaggot_at_hiwaay.net> wrote in article
<xu7Lkn$18GA.164_at_news2.ingr.com>...

> I have a package that contains a procedure called
> GetVersion ( p_Version INTEGER). Is it possible to call
> this procedure from OCI such that the version gets returned
> into a "C" variable, ie,
>
> int main ()
> {
> int version;
> char *SQL = "BEGIN MyPackage.GetVersion(version); END;";
>
> /* logon, parse, bind, define, exec, fetch, whatever */
>
> if (version = 1)
> do_version1_stuff();
> else
> etc.
> }
>
> How do I do this?
>
> Thanks, Ed
>
>
>
>
Received on Tue Oct 14 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US