DBMS_Metadata error - not working at all

[Gustavo]

Right-click a table name, select dbms_metadata --> DDL. The following error is thrown:

ORA-31603: object "NXT_BR_FAT_SUBST_TRIB" of type TABLE not found in schema "NXT"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 653
ORA-06512: at "SYS.DBMS_METADATA", line 1260
ORA-06512: at line 16

Same from Object Browser.

Describe, View and Edit methods work fine.

PLSD Version 7.1.5.1403
Oracle 9.2.0.8

Regards,
Gustavo

 

[Marco Kalter]

Do you have privileges for the NXT.NXT_BR_FAT_SUBST_TRIB type? If so, are these privileges granted directly to your Oracle User or indirectly through a Role?

 

[Gustavo]

The object is not a TYPE, it is "of type TABLE". And I have privileges to it both directly and through a Role (well, 2 roles).

 

[Marco Kalter]

I'm not sure what could cause this. It fails inside the sys.dbms_metadata package, so it's difficult to trace.

 

[Gustavo]

Same thing (exactly the same error) in PLSD 8 RC2. Is there anything I can do to help trace it?

Regards,
Gustavo

 

[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.

 

[Gustavo]

I just sent the file to your e-mail. DB version is 9.2.0.8.

Regards,
Gustavo

 

[dha66]

Did you find a solution?

Regards
Dirk

 

[Marco Kalter]

This was a problem with the sys.dbms_metadata package. If you have a similar problem, can can you modify the shortcut and add the debugsql parameter as well? 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 or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).