PLSQL Developer closes it self when querying from hz_locations table MDSYS.SDO_GEOMETRY

[Zikkom]

Dear All,

I have a problem, maybe there is already a solution which I don't know yet.

PLSQL Developer closes itself without notification, when querying from hz_locations table if you include a column called GEOMETRY and its type is MDSYS.SDO_GEOMETRY

Settings are;

Version 8.0.4.1514
Windows XP Professional 5.1 Build 2600 (Service Pack 3)
DLL: C:\ORANT\bin\oci.dll
OCI: Version 8.0
Oracle9i Enterprise Edition Release 9.2.0.8.0

Character Sets
Character size: 3 byte(s)
CharSetID: 871
NCharSetID: 871
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1
NLS_CHARACTERSET: UTF8
NLS_NCHAR_CHARACTERSET: UTF8

Best regards

 

[Marco Kalter]

This is a known Oracle 8.0 client bug. You will need to upgrade to an Oracle 8.1 or later client. If you already have multiple Oracle Homes on your PC, go to Tools > Preferences > Oracle / Connection to select a newer Oracle Home than your 8.0 Home.

 

[Zikkom]

Thanks Marco,

I now have changed it to a newer version and went fine.

Regards