Re: Procedure - how get the output value in sql+

In article <8di16i$rnq$1_at_nnrp1.deja.com>,   newdb_at_my-deja.com wrote:
> I am new to Oracle and its PL/SQL.
> How can I get the output value of a procedure in sqlplus?
> Example:
> create or replace procedure p_newid (oldid IN number, newid out
> number ) is
> wn number;
> begin
> select ..... into wn;
> newid := wn;
> end;
> /
>
> When executing in sql+
> exec p_newid(1); I get
>
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to
> 'P_NEWID'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

SQL> variable x number
SQL> exec p_newid( 1, :x );
SQL> print x

will do it...

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.