How to get output value of stored procedure in sql plus

From: Calvin Ni <haitao_at_yesic.com>
Date: Tue, 25 Jan 2000 03:31:28 GMT
Message-ID: <388D1B0C.E71854BB_at_yesic.com>

Hi,guys,
[Quoted] 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 - 04:31:28 CET