getclobval function for xml not automatic if not owner

[David K]

If I log in as the owner of a table that has a clob that stores xml, and I right-click the table and select query data, the getclob function is automatically inserted and I can view the xml with the large data editor. If I am not logged in as the owner, then the function is not inserted.

I using version 7.0.2.1076 with Oracle 9.2.0.6.0.

 

[Marco Kalter]

This works fine for me. Is the user the only variable here? It's the same table, in the same database?

 

[David K]

That is correct. The table and database are the same. The only difference is the user.

 

[Marco Kalter]

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

 

[David K]

Marco,

I have emailed the debug file to you. Please let me know what you found.

Thanks