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

try exectuing through a begin/end type of model.

Begin

    p_newid(var1,var2);
End;

I would suggest using SQL Worksheet if you have it. Much nicer interface, and easier to use.

To see what you parameter value is afterwards, use DBMS_OUTPUT to send your information to the output window (SQL Worksheet). You will have to set serveroutput on.

<newdb_at_my-deja.com> wrote in message news:8di3fj$ugo$1_at_nnrp1.deja.com...
> 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.
Received on Tue Apr 18 2000 - 00:00:00 CDT