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

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

From: Calvin Ni <haitao_at_yesic.com>
Date: Tue, 25 Jan 2000 03:38:55 GMT
Message-ID: <388D1CD0.784BA97E@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 Mon Jan 24 2000 - 21:38:55 CST

Original text of this message

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