Re: Call a store procedure in a SQL statement

Jean-Paul Joanany wrote:

> Hi,
>
> I have written a stored procedure and i am able to call it from a java
> application. Now I would like to call the same procedure into a SQL
> statement fo initializing a column into a table. I know how to pass the
> input parameters, but how to specify the variable the return value must be
> copied in.
>
> Thanks in advance
>
> jean-paul

Use an anonymous block:

DECLARE
   x VARCHAR2(20);
BEGIN
   exec my_proc(x);
END;
/

Daniel Morgan Received on Tue Oct 15 2002 - 10:21:10 CDT