Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to get output value of stored procedure in sql plus?
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
![]() |
![]() |