Re: OCI and Stored Procedures

From: Tom Poindexter <tpoindex_at_nyx10.cs.du.edu>
Date: 1997/07/03
Message-ID: <5pgguo$3ur@nyx10.cs.du.edu>#1/1

In article <33B8E915.2DCD_at_gwdg.de>, Stefan von Brauk <sbrauk_at_gwdg.de> wrote:
>Hi all,
>
>I have some problems calling a stored procedure with OCI like
>oexec("EXEC myProc(10)"); as result Oracle returns 900 (no SQL-command).
>Is there a way to call stored procedures?

Try:

oparse(&cur, "begin myProc(10); end;", -1, DEF_FLAG, LNG_FLAG); oexec(&cur);

-- 
Tom Poindexter   
tpoindex_at_nyx.net
http://www.nyx.net/~tpoindex/

Received on Thu Jul 03 1997 - 00:00:00 CDT