Hi,
When I edit this package, the code contents window doesn't show me all the functions in the package.
If I comment the dbms_output line in the second function, then I see the third function in the code contents window.
Is that a bug or a feature ?
I use the 5.1.3.704 trial version.
Here is the source code of the faulty package:
create or replace package toto is
function func_1(p_parm varchar2) return boolean;
end toto;
/
create or replace package body toto is
-- Function and procedure implementations
function func_1(p_parm varchar2) return boolean is
begin
return(true);
end;
function func_2(p_parm varchar2) return boolean is
begin
dbms_output.put_line(CASE (1>0) WHEN TRUE THEN '1' ELSE NULL END | | ',' | |
CASE (1>2) WHEN TRUE THEN '2' ELSE NULL END);
return(true);
end func_2;
function func_3(p_parm varchar2) return boolean is
begin
return(true);
end func_3;
end toto;
/
When I edit this package, the code contents window doesn't show me all the functions in the package.
If I comment the dbms_output line in the second function, then I see the third function in the code contents window.
Is that a bug or a feature ?
I use the 5.1.3.704 trial version.
Here is the source code of the faulty package:
create or replace package toto is
function func_1(p_parm varchar2) return boolean;
end toto;
/
create or replace package body toto is
-- Function and procedure implementations
function func_1(p_parm varchar2) return boolean is
begin
return(true);
end;
function func_2(p_parm varchar2) return boolean is
begin
dbms_output.put_line(CASE (1>0) WHEN TRUE THEN '1' ELSE NULL END | | ',' | |
CASE (1>2) WHEN TRUE THEN '2' ELSE NULL END);
return(true);
end func_2;
function func_3(p_parm varchar2) return boolean is
begin
return(true);
end func_3;
end toto;
/