TIMESTAMP error

[David Shadovitz]

When I attempt to select a column of type TIMESTAMP, PL/SQL Developer throws the following error and returns no data:

ORA-01406: fetched column value was truncated

Here's what PL/SQL Developer's "About" window says:

PL/SQL Developer 5.0.2.500.
OCI: Version 8.1
DLL: C:\oracle\ora92\bin\oci.dll
Oracle 9i Enterprise Edition Release 9.2.0.1.0

I want to be able to run a simple "SELECT * FROM ..." command, so please don't suggest casting or converting the data in my query.

Is there a PL/SQL Developer setting that I must modify?

Thanks for any help.

 

[Marco Kalter]

Version 5.0.2 does indeed not support timestamps. This has been added in 5.0.3, so you will need a minimal upgrade.

 

[David Shadovitz]

Thanks, Marco. Now I must navigate my company's bureaucracy for the $60.
-David