Re: Pb with Pro*c

A copy of this was sent to Herve filliere <herve_filliere_at_yoni.fr> (if that email address didn't require changing) On Wed, 26 May 1999 16:41:13 +0200, you wrote:

>hi everybody,
>
>i would like tu use a PL/SQL function in pro*c.
>please give me syntax.
>
>i have an example:
>declare a number;
>execute a:=recherche(:a);
>
>sincerly.
>hervé.

 exec sql execute
 begin

     :a := recherche(:a);
 end;
 end-exec;

and make sure to set SQLCHECK=SEMANTICS and USERID=u/p on the proc precompile command as well.

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed May 26 1999 - 11:02:23 CDT