BUG - Editing Invalid Package Bodies - 7.0.1.1066

[PhatKlown]

Upon upgrading to the most current version of PL/SQL Developer, I went to look at invalid objects, tried to edit an invalid package body, and got:

/* Source of PACKAGE BODY XYZ is not available */

This happens any way that I try to edit the Package body...

Tried this:
Browse to the object, Right click, Edit or Edit Spec and Body.

Tried various other methods to get the code on the screen - view, edit, sledgehammer, etc. and had no luck.

I need this functionality restored ASAP!

Thanks!
Rob Nasser
rnasser@reedbusiness.com

 

[PhatKlown]

More information...

This may not be relevant to just Release 7.x

We found the same to be true in version 6.x

An important point that also needs to be known.. This only happens when logged in as SYS/SYSDBA.

Rob Nasser
rnasser@reedbusiness.com

 

[PhatKlown]

Even more info...

It seems to be specific to the SYSDBA privilege. I log in as myself without SYSDBA, and I have no problems. I log in as myself/SYSDBA and I hit the issue.

Rob Nasser
rnasser@reedbusiness.com

 

[Marco Kalter]

Have you enabled the preference "Use DBA views if available" (Tools > Preferences > Oracle / Options)?