ORA-04044 in Compare Objects

[Kristi M]

I have successfully used compare objects with several schemas in my database. However, with one particular schema, as soon as I pick the drop-down I get the message "ORA-04044 procedure, package, function or type is not allowed here."

Then it shows me the compare screen but no objects are available to be picked.

Interestingly, it does it for this particular schema in my production, test and development databases (but not for any other schemas in any of these databases). What should I be looking for to fix this?

Thanks,
Kristi M

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.