SDO_GEOMETRY

[Patrick Fister]

Hello

If I try a select on a view which contains sdo_geometry in nested types pl/sql developer returns with a ORA-04043: object SDO_GEOMETRY does not exist.
If I do the same on sqldeveloper from oracle it works.
Is this not possible in pl/sql developer?

Regards,
Patrick

 

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