Oracle 9i TIMESTAMP datatype

[William Robertson]

I create a table in SQL*Plus as:

CREATE TABLE test_ts (ts TIMESTAMP);

INSERT INTO test_ts VALUES (SYSTIMESTAMP);
INSERT INTO test_ts VALUES (SYSTIMESTAMP);
INSERT INTO test_ts VALUES (SYSTIMESTAMP);
COMMIT;

When I go into PL/SQL Developer and try to query the data, I get:

ORA-03120: Two-task conversion routine: integer overflow

TOAD 7.3, TOra and OraEdit give similar errors. Is there a fix on the horizon? We are just starting to use TIMESTAMPs and this could be a big advantage for PL/SQL Dev if it was the only IDE to support them.

[This message has been edited by WilliamRobertson (edited 19 September 2003).]

 

[Marco Kalter]

My guess is that the Oracle Net version of your Primary Oracle Home does not support timestamps (8.0 or earlier). Could this be the case? If so, you will need to upgrade it to 8.1 or later.

------------------
Marco Kalter
Allround Automations

 

[William Robertson]

Well on my PC that's the case but one guy here has Oracle 9.2 client and still got the error - I'll investigate further though.

 

[orca777]

Hi,
i thinks it's a problem of the client Software not the driver, The software does not know how to process the new timestamp-type; even a correct oracle client would not help

Orca

 

[orca777]

Hi,
i thinks it's a problem of the client Software not the driver, The software does not know how to process the new timestamp-type; even a correct oracle client would not help

Orca

 

[Marco Kalter]

PL/SQL Developer does know how to handle timestamps.

------------------
Marco Kalter
Allround Automations