PL/SQL Dev 6 and Oracle 10g - Problems

[t21931]

Hi everyone,

My company is using PL/SQL Developer 6.0.5 with Oracle Client 9i installed (for SQLNET client).

We've started connecting to an Oralce 10G database and some developers have experienced problems.

Specifically, PL/SQL Developer just quits/shuts down for no apparent reason.

Has anyone seen this before? Should we install Oracle 10G SQLNET Client?

THANKS!

- Pedro

 

[Marco Kalter]

Can you let me know the exact Oracle Server version?

 

[t21931]

The Oracle 10G database that we connect to is:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

 

[Marco Kalter]

In that case you need to upgrade to PL/SQL Developer 6.0.6, or apply the Oracle 10.2.0.2 patch.

 

[t21931]

Thanks - how do I get either the patch or the updgrade? I only see PL/SQL Dev 7 in the download section.

 

[t21931]

Any updates?

 

[nigel pendall]

Hi,

We are seeing something very similar - however we are already using Version 7.0.0.1050 (MBCS)7.

The problem occurs when querying tables with clobs
some rows load but others return in the clob column. after a few such rows connection with database is lost.

 

[t21931]

We've seen this too - I thought it was related to the version we're using.

Maybe there's something larger going on.

 

[Marco Kalter]

This seems like a different problem to me. Version 7.0 should not have any problem with Oracle 10.2.

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.

 

[snjn04]

We are experiencing a problem with version 7.0.0.1050 and Oracle 10.2.
When expanding the tables

 

[snjn04]

I have uploaded the debug.txt to support@allroundautomations.com

 

[miz]

i have the same issue with expanding the tables' tree. plsql developer version 7.0.2.1076, Oracle 10.2g

 

[Marco Kalter]

Can you do the same test I suggested above?

 

[P.Jakob]

I have a similiar performance problem when viewing or editing a user. After selecting a user it takes more than a minute till the data of the user appears. I will send the debug and version information to support@allroundautomation.com

Kind regards,

Peter