Attempting to access table with TIMESTAMP datatype in SQL window

[B_P_100]

I am running PL/SQL Developer 7.1.0.1337 over a 10.2.0.2.0 database.

I have a simple table containing a column with a datatype of TIMESTAMP.

When I attempt to select from this table using the
SQL window (or command window) I get error:

ORA-03115: unsupported network datatype or representation.

When I use SQL*Plus on my system I can select from this table.

Any idea on how to fix this?

 

[Marco Kalter]

This indicates that the Oracle Net version of your Primary Oracle Home is too old to support timestamps. If SQL*Plus works okay, then I assume that it is from a more recent Oracle Home.

To resolve this, go to Tools > Preferences > Oracle / Connection, and select the correct Oracle Home. Restart PL/SQL Developer and check if it helped.

 

[B_P_100]

Thanks. I was able to solve the problem with your advice.