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 -> Return PLSQL variable value to OCI

Return PLSQL variable value to OCI

From: Edward Baggott <eabaggot_at_hiwaay.net>
Date: 1997/10/13
Message-ID: <xu7Lkn$18GA.164@news2.ingr.com>#1/1

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 Mon Oct 13 1997 - 00:00:00 CDT

Original text of this message

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