Request: visual indication of compilation error in program window, even if no error line number

[Claus Pedersen]

We are using the option in the database PLSQL_WARNINGS = 'ENABLE:ALL'.

Normally in program windows, we get Oracle errors + Oracle generated compiler hints + PL/SQL Developer warnings.

But due to a bug in the 10.2 database, in some cases only the Oracle PLW-warnings are displayed, but no PLS-errors. The database reports that the compilation resulted in errors, but no Oracle errors are reported in the "user_errors" view.

So my request is: When PL/SQL developer reports "Compiled with errors" and Oracle does not report any error lines, would it be possible that the first line in the program window was marked yellow, or some other way indicating to the user that some unexpected situation has occured. Today, some users may overlook the small message "Compiled with errors" in the status line.

It would also be a very nice feature, if it could be possible to display a dummy Oracle error saying something like: "1 PLS-??? Compilation errors, but no error line reported by Oracle" in the message window.

For those who have a technical interest in this issue, here is a sample code that will generate the error (PLSQL_WARNINGS must be turned on in the database):

CREATE OR REPLACE PACKAGE tester IS
END tester;
/
CREATE OR REPLACE PACKAGE BODY tester IS
  PROCEDURE test1 (p1 OUT VARCHAR2,
                   p2 OUT VARCHAR2,
                   p3 OUT VARCHAR2,
                   p4 OUT VARCHAR2,
                   p5 OUT VARCHAR2,
                   p6 OUT VARCHAR2,
                   p7 OUT VARCHAR2,
                   p8 OUT VARCHAR2,
                   p9 OUT VARCHAR2,
                   p10 OUT VARCHAR2,
                   p11 OUT VARCHAR2,
                   p12 OUT VARCHAR2,
                   p13 OUT VARCHAR2,
                   p14 OUT VARCHAR2,
                   p15 OUT VARCHAR2,
                   p16 OUT VARCHAR2,
                   p17 OUT VARCHAR2,
                   p18 OUT VARCHAR2,
                   p19 OUT VARCHAR2,
                   p20 OUT VARCHAR2) IS
  BEGIN
    p1 := p_21;
  END;
END tester;
/

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Claus Pedersen]

Thanks