SQLNetv2-Listener bad Timezone
Date: 1995/11/23
Message-ID: <492b4m$7hd_at_nz12.rz.uni-karlsruhe.de>#1/1
Hello,
I've a Problem with the SQLNet V2-Listner:
When I connect to Oracle without use of the Listener or with use of a V1-Connection (orasrv) Oracle shows the right Time (in my case CET-1CES).
But when i use a V2-Connection, Oracle shows a false time (not the right Timezone)
Example:
connect scott/tiger_at_T:hostname:sid
select to_char(sysdate,'hh24":"mi":"ss') from dual;
-> 12:00:00 OK - right Time
connect scott/tiger_at_v2service
select to_char(sysdate,'hh24":"mi":"ss' from dual;
-> 6:00:00 NOT OK - ERROR ! using no timezone-parameter
The Listener himself konws the right time as I can see in the Listner-Log-File
I use Oracle 7.1.6 (HP-UX 09.05)
SQLNet 2.1.6
Has anyone an idea ?
Thank a lot !
stefaN.
Stefan Scheck
Akademische Software Kooperation
Universitaet Karlsruhe
76128 Karlsruhe
Germany
e-mail: scheck_at_ask.uni-karlsruhe.de
Received on Thu Nov 23 1995 - 00:00:00 CET