Compilation error list not displaying

[Kenneth Acosta]

When compiling package body within the Program Window receiving "Compiled with errors" message but the compilation error list is not displaying.

This started to happen once I upgraded to PL/SQL Developer version 10.0.5.1710

How do I get the compilation error list displayed?

 

[Marco Kalter]

Does this happen with all program units or just this package body?

If it's just this package body, can you send me the source?

 

[Kenneth Acosta]

It is happening to all program units where adding a label at the end. When compiling from a script

example
CREATE OR REPLACE PACKAGE BODY tf_revenue_recgn_pkg AS
...
END tf_revenue_recgn_pkg;
/

How can I send you the source?

 

[Marco Kalter]

You can send it by e-mail.

 

[mike]

I wonder if I'm having the same problem.

Recently, our logins changed. We used to login with the apps user when we compiled source. Now, we are going to have our own user name and connect to with proxy to apps. This is new to me, so if I'm saying it wrong, this is what we do: For the username, I login as "myusername[apps]". I hope that makes sense.

Everything works, but the errors from compiled programs do not show up when I compile. I can select from DBA_ERRORS and see the errors. If I login using the apps user directly, then the errors show up when I compile. Also, if I open the package in the object browser, the errors show up.

 

[mike]

Perhaps this is a clue. If I login proxied to APPS, and run these commands in the command window (I shortened the error messages and replace my username with USERNAME):

SQL> show errors package body zper_afscme_increase;
No errors for PACKAGE BODY USERNAME[APPS].ZPER_AFSCME_INCREASE

SQL> show errors package body apps.zper_afscme_increase;
Errors for PACKAGE BODY APPS.ZPER_AFSCME_INCREASE:
LINE/COL ERROR
--------
472/24   PL/SQL: ORA-00917: missing comma
471/10   PL/SQL: SQL Statement ignored
660/7    PLS-00103: Encountered the symbol "PROCEDURE" ...
660/58   PLS-00103: Encountered the symbol ">" when expecting one of the following: ...

I think that perhaps pl/sql developer is calling the show errors function incorrectly in this case.

 

[Stoyan Ivanov]

We noticed the same behavior in the Program Window: It shows "Compiled with errors" message but the compilation error list is not displaying.

We are not using proxy users like mike.

Also, after I exit PL/SQL Developer and restart it, the problem disappears. So, it is not from the start ...

Sorry, I know this information is insufficient! If I notice more clues, I'll post again.

 

[Sgnao]

I had the same problem.

I post here the reply that made me solve it.

1) sounds to me that you have too many warnings generated by Oracle. For some reason, Oracle can not show more than 20 warnings/errors and when you have 20+ warnings, you will not see any errors at all.
Go into Tools - Preferences -> Oracle -> Compiler -> PL/SQL Warnings and select Disabled for all exceptions and see if this helps.

2) Do you have Safe compilation turned on? (Tools - Preferences -> Window Types -> Safe compilation). This will generate temporary object names like you described.

Hope this will help you ...

Hope this will help you too.

Marco