in out param and PLS-00204 error in pl/sql
From: nutron <nutron2000_at_yahoo.com>
Date: 4 Sep 2002 08:48:57 -0700
Message-ID: <e4ed71f5.0209040748.748acca5_at_posting.google.com>
set serveroutput on;
set line 200;
nutron Received on Wed Sep 04 2002 - 17:48:57 CEST
Date: 4 Sep 2002 08:48:57 -0700
Message-ID: <e4ed71f5.0209040748.748acca5_at_posting.google.com>
set serveroutput on;
set line 200;
CREATE OR REPLACE PROCEDURE explode1(level in out number, item character) AS
BEGIN
level := level+1;
DBMS_OUTPUT.PUT_LINE('level='|| level ||'item=' || item);
END;
/
show errors
declare
inp number := 0;
begin
explode1(inp,'test');
end;
/
Warning: Procedure created with compilation errors.
Errors for PROCEDURE EXPLODE1:
LINE/COL ERROR
-------- ----------------------------------------------------------------- 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