Oracle 9i client causes developer to close

[Brent Claxton]

I have PL/SQL Developer version 5.1.4.730 installed. I have a server running several instances of Oracle (1-9.2.0.1.0, 2-8.1.7) using different character sets and the Oracle 9.2.0.1.0 client installed on my PC.

It seems that each time I try to edit a table in the instance running 8i with a windows character set, PL/SQL Developer simply closes.

If I check "Force OCI7 mode on OCI8" on the preferences it seems to work okay but the help indicates that I will access to the clob data when I check that option.

It also seems to work on machines with the 8i client installed but I don't really want to go installing more clients.

I'm fairly new to PL/SQL Developer and wondered if anyone had any suggestions.

Brent

 

[Marco Kalter]

This is an Oracle Net 9.2 bug. It cannot query long fields from an Oracle8i database. You can reproduce it in SQL*Plus 9.2:

SQL> select * from all_tab_columns;

If this returns 1 or more rows in an Oracle8i database, SQL*Plus 9.2 will crash.

All you can do is use Oracle Net 9.0 or earlier.