OCI application-Procedure problem...

From: Jacques Sireude <sireude_at_eiffel.com>
Date: Tue, 14 Jul 1998 08:53:45 -0700
Message-ID: <6ofur1$d74$1@news.rain.org>

Hi,

I would like to do so:

sql_statement= "create procedure (name VARCHAR2, tmp_row DB_BOOK%rowtype) as begin select * into tmp_row from DB_BOOK where AUTHOR = name; end;";

then:

oparse (&cda, sql_statement...)

then

odescr, odefin with the same CDA.

then oexec (&cda).

Everything is working fine...
But when I want to execute the procedure:

sql_statement="execute DB_BOOK_PROC ('sireude', tmp_row)" then
oparse, odescr, odefin, oexec... In fact I do not know how to do...

Thanks for any help... and sorry if it is not clear enough...

Jacques.

Jacques SIREUDE
6585 PICASSO Rd Apt#3
ISLA VISTA CA 93117
USA
tel/fax: 1-805-685-9208
e-mail: sireude_at_eiffel.com

jacques.sireude_at_enst-bretagne.fr

http://www-eleves.enst-bretagne.fr/~sireude



----------------------------------------------------------------------------


----------------

Received on Tue Jul 14 1998 - 10:53:45 CDT