Home -> Usenet -> comp.databases.oracle -> Re: Stored procedure calls from OCI

Re: Stored procedure calls from OCI

From: C.A. Verruyt <verruyt_at_inter.NL.net>
Date: Sat, 8 Oct 1994 23:19:15 GMT
Message-ID: <CxDnG3.Iv7_at_inter.NL.net> 







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.


>>




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




-- 
------------------------------------------------------------------------------
Cornelis A. Verruyt
KEVERSOFT B.V., The Netherlands
E-mail: verruyt_at_inter.NL.net or kees_at_redwood.nl


Received on Sun Oct 09 1994 - 00:19:15 CET












Original text of this message