Hiding exception ORA-24344: success with compilation error

[Andrey.L]

When I create SP which creates invalid SP then PL\SQL developer (SQL Window, Test Window) doesn't show exception message.

Steps to reproduce:

create or replace procedure p1
as
  v_sql varchar2(32767);
begin
  dbms_output.put_line('p1 start');
  v_sql := '
create or replace procedure p2 as
begin
  dbms_output.put_li ne(''p2'');
end;
';
  dbms_output.put_line(v_sql);
  execute immediate v_sql;
  dbms_output.put_line('p1 finish');
end;
/

begin
  p1;
end;
/

SQL*Plus shows following spool

SQL> create or replace procedure p1
  2  as
  3    v_sql varchar2(32767);
  4  begin
  5    dbms_output.put_line('p1 start');
  6    v_sql := '
  7  create or replace procedure p2 as
  8  begin
  9    dbms_output.put_li ne(''p2'');
 10  end;
 11  ';
 12    dbms_output.put_line(v_sql);
 13    execute immediate v_sql;
 14    dbms_output.put_line('p1 finish');
 15  end;
 16  /

Procedure created.

SQL>
SQL> begin
  2  p1;
  3  end;
  4  /
ERROR:
ORA-24344: success with compilation error
ORA-06512: at "CFG.P1", line 13
ORA-06512: at line 2

Warning: PL/SQL compilation errors.

Command window PL\SQL Developer's shows

SQL>
Warning: PL/SQL procedure successfully completed with compilation errors

It is better than "successfully" in Test & SQL windows

Please, Can you fix it.

 

[Marco Kalter]

We'll check it out.