Re: Stored procedure calls from OCI

verruyt_at_inter.NL.net (C.A. Verruyt) writes:
>chadb_at_NeoSoft.com writes:
>>In <369j03$sle_at_freenet3.scri.fsu.edu>, howardh_at_freenet3.scri.fsu.edu (Howard Hartsfield) writes:
>>>I am attempting to write a C OCI application that calls a stored
>>>procedure; the problem is, I can't figure out the form that the
>>>procedure call should take or how to get variables into/out of it. If
>>>I just call the stored procedure with constants I get an "invalid sql
>>>statement" error (I have tried calling it with and without 'execute'
>>>in front of the procedure name). If I place host variables in the
>>>procedure name and bind them to buffers, I get the same error. What
>>>am I doing wrong? I have been unable to find a single example of this
>>>in the documentation.

In the Version 7.0 manual, the example starts on p. 2-29.

>I think your problem is that you can only call procedures in PLSQL.
>So try he following: oparse( ,"begin stored_proc(:b1, :b2); end;", ...);
>;

And remember that you have to use obndrv or obndra, not odefin, to bind all parameters, both ins and outs.

--Tim (tssmith_at_oracle.com) Received on Mon Oct 10 1994 - 02:52:30 CET