| ORA-01810: format code appears twice, followed by ORA-12560 ! [message #67628] |
Wed, 24 November 2004 23:46  |
Lars Erkki
Messages: 2
Registered: November 2004
|
Junior Member |
|
|
Hi !
Can anybode give me a hint on what it could be that causes this phenomenoun ? Sample login showed below:
C:>sqlplus system/manager@stand1
SQL*Plus: Release 8.1.7.0.0 - Production on Tor Nov 25 10:43:45 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-01810: format code appears twice
Ange anvõndarnamn:
ERROR:
ORA-12560: TNS: protokolladapterfel
...
..
Thanks in advance !
|
|
|
|
| Re: ORA-01810: format code appears twice, followed by ORA-12560 ! [message #67629 is a reply to message #67628] |
Thu, 25 November 2004 01:40  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Here is a solution direct from Metalink :
This is genrally because the client and server date formats are different.
Client is sending data in RRRR format while the database is expecting
only RR format.
1.Modify the NLS_DATE parameter in the registry.
2.Start the registry editor
Find the ORACLE key
3.HKEY_LOCAL_MACHINE > Software > ORACLE
4.Single click on it to populate the right-hand window
In the right-hand window, look for the value NLS_DATE (or NLS_DATE_FORMAT) and double click on it.
5. Change the value to read DD-MON-RR
If the value is not present add it by selecting Edit > New > key
Add the key with the above information.
Daljit Singh.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
