Thanks you,
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3DAC3260.F56F0865_at_exesolutions.com...
> 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:58:38 CDT
