systimestamp

[radino]

Hi,
PL/SQL Developer version: 7.0.3.1123
OS: Win XP SP2
I get this error in Command Window and SQL Window:

Connected to Oracle9i Enterprise Edition Release 9.2.0.4.0
Connected as einvoice

SQL>
SQL> select to_char(systimestamp, 'DD.MM.YYYY HH24:MI:SS') from dual;

TO_CHAR(SYSTIMESTAMP,'DD.MM.YY
------------------------------
20.10.2006 14:41:54

SQL> select systimestamp from dual;

select systimestamp from dual

ORA-03106: fatal two-task communication protocol error

SQL>

When I try to select table with timestamp column
Developer freezes. (In SQL Window and in Command Window)
When I canceled query a got this message:
Access violation at address 67858DB3 in module 'NS80.dll' Read of address 000000CC.
and developer was still not responding..

Could you give me any advice?
Thank you

 

[Marco Kalter]

I assume this problem is caused by the fact that you are using an 8.0 client, which does not know the timestamp data type. You will probably need to upgrade to a 9.0 or later client.

If you have multiple Oracle Homes, you can select a different home through Tools > Preferences > Oracle / Connection.

 

[radino]

Thank you,
You are right.. I have multiple Oracle Homes, and home for Oracle 8.1.7 was autodetected.