Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Return PLSQL variable value to OCI
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