Knowledge Base

Only use valid format mask,and do not repeat

ORA-01810: Format code appears twice

If you are accessing data over a database link you can get this error if the database version you’re connecting to does not know some of the NLS parameters of the database you’re connecting from.
eg. Oracle 7.1.6 does not know the date format RRRR, so if the database you’re connecting from has NLS_DATE_FORMAT set to ‘DD/MM/RRRR’ and you’re connecting to a 7.1.6 (anything lower than 7.2), this error will occur.

SQL> select * from v$;

Oracle7 Server Release - Production Release

SQL> select * from;


SQL> alter session set NLS_DATE_FORMAT='DD/MM/RRRR';
ORA-01810: format code appears twice
ORA-02063: preceding line from 713.WORLD

Last error occurred immediate because the database link was still open.

Leave a Reply

You must be logged in to post a comment.

Oracle Gold Partner DbMotive is an Oracle Silver Partner