disappearing

bellda

Member
Soemtimes (rather often) plsqldev just disappears. No error message, just disappears. Anyone got the clue? Thanx
 
Could it be that you are using Oracle Net 9.2 on an Oracle8i database? There is a bug in Net 9.2 when querying long columns in an 8i database. To verify this, start SQL*Plus 9.2, connect to the 8i database, and execute the following:

SQL> select * from user_tab_cols;

SQL*Plus should also "disappear" when accessing the long column in this view...

------------------
Marco Kalter
Allround Automations
 
HI,

I had similar effects, and ALT-Tab will show that the PL/SQL Developer program is still running and alive. Selecting it thus, would bring it back onto the taskbar.

I think I haven't seen PL/SQl Developer disappear like this since version 5.1.2, definitely not any more since 5.1.3.

------------------
Hakuna Matata,

Arnoud.
 
Originally posted by mkalter:
Could it be that you are using Oracle Net 9.2 on an Oracle8i database? There is a bug in Net 9.2 when querying long columns in an 8i database. To verify this, start SQL*Plus 9.2, connect to the 8i database, and execute the following:

SQL> select * from user_tab_cols;

SQL*Plus should also "disappear" when accessing the long column in this view...


This seems to be the root of all the evil
:-) Is there any patch around?
 
There is no Oracle patch that I am aware of. You can only work around the problem in one of the following ways:
[*] Switch to an Oracle Home with an Oracle Net version older than 9.2.

[*] Install Oracle Net version older than 9.2.

[*] Set the "Force OCI7 mode on OCI8" preference (now you can't use Net8 specific features like LOB's and Objects anymore).[/list]

------------------
Marco Kalter
Allround Automations
 
Originally posted by mkalter:
There is no Oracle patch that I am aware of. You can only work around the problem in one of the following ways:
[*] Switch to an Oracle Home with an Oracle Net version older than 9.2.

[*] Install Oracle Net version older than 9.2.

[*] Set the "Force OCI7 mode on OCI8" preference (now you can't use Net8 specific features like LOB's and Objects anymore).[/list]


Thank you very much, I downgraded to OraNet 8.1.7 and everything's OK
 
Back
Top