Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Call a store procedure in a SQL statement

Re: Call a store procedure in a SQL statement

From: Scott Mattes <Scott_at_TheMattesFamily.ws>
Date: Tue, 15 Oct 2002 13:15:20 GMT
Message-ID: <IxUq9.31778$m92.6084755@news1.news.adelphia.net>


select count(*)

   into myvar
 from dual;

"Jean-Paul Joanany" <jean-paul.joanany_at_pasinternational.com> wrote in message news:aoh12h$kov$1_at_reader1.imaginet.fr...
> 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
>
>
Received on Tue Oct 15 2002 - 08:15:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US