Re: How to test procedure that has OUT params in SQLPlus?

From: <pobox002_at_bebub.com>
Date: 21 Jun 2005 07:29:38 -0700
Message-ID: <1119364178.670888.277720@g43g2000cwa.googlegroups.com>

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

---

output

SQL>

-- 
MJB

Received on Tue Jun 21 2005 - 09:29:38 CDT