Oracle Database Errors or Warnings from Error ORA-12700 to ORA-12709


ORA-12700: invalid NLSS parameter value (string)
Cause: An invalid or unknown NLS configuration parameter was specified.
Action: None
ORA-12701: CREATEE DATABASEE character set is not known
Cause: The character set specified when creating the database is unknown.
Action: None
ORA-12702: invalid NLSS parameter string used in SQL function
Cause: An unknown parameter name or invalid value is specified in a NLS parameter string.
Action: None

ORA-12703: this character set conversion is not supported
Cause: The requested conversion between two character sets in the CONVERTT function is not implemented
Action: None
ORA-12704: character set mismatch
Cause: One of the following:
– The string operands(other than an nlsparams argument) to an operator or built-in function do not have the same character set.

– An nlsparams operand is not in the database character set.

– String data with character set other than the database character set is passed to a built-in function not expecting it.

– The second argument to CHRR() or CSCONVERTT() is not CHAR_CSS or NCHAR_CSS.

– A string expression in the VALUES clause of an INSERT statement, or the SET clause of an UPDATE statement, does not have the same character set as the column into which the value would be inserted.

– A value provided in a DEFAULT clause when creating a table does not have the same character set as declared for the column.

– An argument to a PL/SQL function does not conform to the character set requirements of the corresponding parameter.

Action: None
ORA-12705: Cannot access NLS data files or invalid environment specified
Cause: Either an attempt was made to issue an ALTERR SESSION command with an invalid NLS parameter or value; or the environment variable(s) NLS_LANG, ORA_NLSxx, or ORACLE_HOMEE was incorrectly specified, therefore the NLS data files cannot be located.
Action: Check the syntax of the ALTERR SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify the correct directory path/values in the environment variables.

ORA-12706: this CREATEE DATABASE character set is not allowed
Cause: It is not allowed to create a database on a native ASCII-based machine using an EBCDIC-based character set, and vice versa.
Action: None
ORA-12707: error while getting create database NLSS parameter string
Cause: Internal error
Action: None
ORA-12708: error while loading create database NLSS parameter string
Cause: Internal error
Action: None
ORA-12709: error while loading create database character set
Cause: Internal error
Action: None

Above are list of Oracle Database Errors or Warnings from Error ORA-12700 to ORA-12709 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *