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: How to get output value of stored procedure in sql plus?

Re: How to get output value of stored procedure in sql plus?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 25 Jan 2000 09:20:39 +0100
Message-ID: <86jmcj$87r$1@news4.isdnet.net>


Try this:
variable c char(8)
execute sp1('11',:c)
print c

--
Have a nice day
Michel

Calvin Ni <haitao_at_yesic.com> a écrit dans le message : 388D1CD0.784BA97E_at_yesic.com...
> Hi,guys,
> How can I get the output values of a stored procedure in sql plus?
> I created a procedure sp1(a in char,b out char) and revoke it in sql
> plus as follows:
> execute sp1('11',c)
> How can I get the value of c?
> I did as this:
> declare c char(8)
> execute sp1('11',c);
> select c from dual;
> But I always got error message: should use 'into' in select ......
> Do you have some idea about that?
> Thanks!
>
>
>
Received on Tue Jan 25 2000 - 02:20:39 CST

Original text of this message

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