show errors shows no errors

[Michael McAuley]

Hi,

I compile a package body, and its says errors have occured. I then say show errors and the reply is "no errors". This works in sqlplus... why not the command window? Is this a bug? Is there a workaround? I'm not sure if it matters but the packages are wrapped.

SQL> alter package tx_certificate_pk compile debug body;

Warning: Package body altered with compilation errors

SQL> show errors;
No errors

details of setup

PL/SQL Developer
Version 6.0.3.893 (MBCS)
01.21743 - 15 user license
Windows 2000 version 5.0 (build 2195) Service Pack 4

Physical memory : 523,252 kB (188,340 available)
Paging file : 1,277,276 kB (1,022,348 available)
Virtual memory : 2,097,024 kB (2,040,600 available)

Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins
*FTP File Interface 1.1 (C:\Program Files\PLSQL Developer\PlugIns\ftp.dll)
*SmartEd 2.0 Plug-In (C:\Program Files\PLSQL Developer\PlugIns\SmartEd.dll)
(* is Active)

Aliases
APPS_FIN11P
APPS_FIN11T
ARCHIVEP
BTI
BTI2004
...

Homes
DEFAULT_HOME (C:\Orawin95)

DLLs
C:\Orawin95\bin\oci.dll
C:\Orawin95\bin\ORA73.DLL
C:\Orawin95\bin\ORA803.DLL
C:\Orawin95\bin\ORA804.DLL
C:\Orawin95\bin\ora805.dll

TNS File
C:\Orawin95\Network\Admin\tnsnames.ora

Using
Home: Oracle9ids
DLL: C:\Orawin95\bin\oci.dll
OCI: Version 8.0

 

[mike]

Why not use the program window? I've seen other developers use the command window for this also, but I just don't get it. At best programming with the command window will be as good as SQL plus.

The program window editor is much nicer for this - and it shows the errors.

 

[Michael McAuley]

The program window will not show wrapped code. If it did this would be a workable solution. Thanks for the reply though...

 

[patch]

Maybe that's exactly the problem here. You are trying to compile a wrapped package. It knows it has errors, but it cannot find the errors, because the package body is wrapped.

You say it works in SQL*Plus. Do you mean that you can see the errors there?

 

[Michael McAuley]

Yes, you can see the errors from sqlplus
Command window in developer
SQL> alter package tx_certificate_pk compile debug body;

Warning: Package body altered with compilation errors

SQL> show errors;
No errors

SQLPLUS

SQL> alter package tx_certificate_pk compile debug body;

Warning: Package body altered with compilation errors

SQL> show errors;
PLS/**** (I cant show the error due to sensitive data, but there is one here).

 

[Marco Kalter]

This seems to fail for package bodies. We'll fix it.

 

[vllr]

I have the same problem ("show errors" shows "no errors" for Java. I can get actual error in SQLplus. Would be nice to fix.

Thanks a lot for the perfect product!!!