in out param and PLS-00204 error in pl/sql
Date: 4 Sep 2002 08:48:57 -0700
Message-ID: <e4ed71f5.0209040748.748acca5_at_posting.google.com>
Can someone tell me why the following is wrong? i want to pass a
numeric value to a procedure, modify it and read it back.
CREATE OR REPLACE PROCEDURE explode1(level in out number, item
character) AS
BEGIN
level := level+1;
END;
declare
Warning: Procedure created with compilation errors.
Errors for PROCEDURE EXPLODE1:
LINE/COL ERROR
set serveroutput on;
set line 200;
DBMS_OUTPUT.PUT_LINE('level='|| level ||'item=' || item);
/
show errors
inp number := 0;
begin
explode1(inp,'test');
end;
/
-------- -----------------------------------------------------------------
5/3 PL/SQL: Statement ignored
5/12 PLS-00204: function or pseudo-column 'LEVEL' may be used
inside a
SQL statement only
6/3 PL/SQL: Statement ignored
6/35 PLS-00204: function or pseudo-column 'LEVEL' may be used
inside a
SQL statement only
-----------------------------------------------------------------------
thanks in advance
nutron
Received on Wed Sep 04 2002 - 17:48:57 CEST