Re: Calling An Oracle Procedure

Davide Semprini wrote:
> you cannot exec a procedure from sqlplus that return OUT parameter.

Sure you can:

SQL> create or replace procedure p (p1 out number) 2 is
3 begin
4 p1 := 42;
5 end;
6 /

Procedure created.

SQL> var x number
SQL> exec p(:x)

PL/SQL procedure successfully completed. SQL> print x

         X

        42 Received on Fri Nov 05 2004 - 12:10:04 CST