Timestamp

[molloycp]

Hello,

A simple select from a table that has a few fields of type
TIMESTAMP(6) WITH TIME ZONE

Results in an error of ORA-01877 : string is too long for internal buffer

We're running Version 7.1.5.1398 on oracle version 10.2.0.3.0

Do we need to upgrade our PLSQL Developer?

Chris

 

[Marco Kalter]

Can you try the same with the 9.0.6 trial version?

 

[molloycp]

Just tried it and it did not fix the problem.

Any other ideas?

 

[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 or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[molloycp]

Marco,

I pointed my oracle home in the tool to OraHome92 and the OCI to C:\oracle\ora92\bin\oci.dll

and it now works......yay

Seems like it is due to some strange configuration of multiple oracle homes on my oracle client.

Thanks

Chris

 

[William Robertson]

Or due to using datatypes not supported by an older client? (Assuming the previous Oracle client was earlier than 9.x - wild guess.)