Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to test procedure that has OUT params in SQLPlus?
ohaya wrote:
> Hi,
>
> I have created a procedure called decrypt_inmemory with following
> parameters:
>
> key IN varchar2, data IN varchar2, cleardata OUT varchar2
>
> I was wondering how I can test execute this procedure from within
> SQLPlus?
>
> How do I create a variable to receive the OUT parameter? And, how do I
> display this variable after I test-execute the procedure?
>
> Thanks,
> Jim
You create a bind variable in SQL*Plus, look up the SQL*Plus Reference manual at http://docs.oracle.com for complete information.
SQL> create or replace procedure p (s out varchar2
2 as
3 begin
4 s := 'output';
5 end;
6 /
Procedure created.
SQL> var s varchar2(100)
SQL> exec p(:s)
PL/SQL procedure successfully completed.
SQL> print s
S
SQL>
-- MJBReceived on Tue Jun 21 2005 - 09:29:38 CDT