Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Procedure - how get the output value in sql+
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