No. 11000 ~ 11999
11001: Subquery returned a tuple where a scalar value was expect ed.
Cause More than one column was returned by a subquery.
Action Check if there are more than two columns in the selection list of the scalar subquery.
11002: Subquery returned multiple rows where a scalar value was expected.
Cause A subquery expected to return a scalar value returned more than two rows.
Action Check the scalar subquery.
11003: Invalid function argument type.
Cause The function argument type is invalid.
Action Check the declaration of the function.
11004: Invalid function argument.
Cause The specified function argument is invalid.
Action Check the declaration of the function.
11005: Specified value '%1$s' is invalid for mathematical function argument(s).
Cause The specified mathematical function argument is invalid.
Action Check the declaration of the function.
11006: Invalid USERENV parameter.
Cause The input is invalid for the USERENV function parameter.
Action Ensure that the function parameter is CLIENT_INFO, ENTRYID, ISDBA, LANG, LANGUAGE, SESSIONID or TERMINAL.
11007: The TRIM set may not contain more than one character.
Cause The first parameter of the TRIM function contains more than one character.
Action Specify only one character for the first parameter.
11008: Escape character must be one character long.
Cause The length of the escape character in the LIKE clause does not equal 1.
Action Set a single character for the escape argument.
11009: Invalid use of escape character.
Cause Invalid use of escape character.
Action The percent sign "%", underscore "_", and the escape character itself are the only characters permitted to follow an escape character.
11010: TO_CHAR format cannot be specified for this data type.
Cause The TO_CHAR format cannot be specified for this type.
Action Remove the format from the function formula.
11011: TO_DATE format cannot be specified for this data type.
Cause The TO_DATE format cannot be specified for this type.
Action Remove the format from the function formula.
11012: TO_TIME format cannot be specified for this data type.
Cause The TO_TIME format cannot be specified for this type.
Action Remove the format from the function formula.
11013: TO_TIMESTAMP format cannot be specified for this data type.
Cause The TO_TIMESTAMP format cannot be specified for this type.
Action Remove the format from the function formula.
11014: TO_NUMBER format cannot be specified for this data type.
Cause The TO_NUMBER format cannot be specified for this type.
Action Remove the format from the function formula.
11015: Input parameter string is too long.
Cause Part of the input parameter string was too long.
Action Shorten the length of the string.
11016: Unsupported multi-byte character set in CLOB.
Cause An attempt was made to use a CLOB with a multi-byte character set.
Action Use single-byte character sets, or do not use a CLOB.
11017: The relational operator accepts only boolean values.
Cause A non-boolean operand was specified for the relational operator.
Action Verify that the operand is a boolean operand.
11018: Operator does not accept operands of the given data type.
Cause The operand type is invalid.
Action Input a valid operand type for the operator.
11019: Concatenation applied to invalid data type.
Cause The CONCAT operation may not be used on this data type.
Action Use CHAR, VARCHAR or CLOB, or use a value that can be converted to one of those data types.
11020: String concatenation result is too long.
Cause The result of a string concatenation is too long.
Action Make sure that the total length of the concatenation result 65,531.
11021: Error occurred during type casting.
Cause An attempt was made to convert the data type to an invalid data type.
Action Check the specified data type.
11022: Values are from incompatible data types.
Cause The values are from incompatible data types.
Action Modify the data types to be compatible.
11023: Values are from data types that cannot be compared.
Cause The values are from incomparable data types.
Action Modify the data types to be comparable.
11024: Cardinality mismatch found during group comparison.
Cause During a group comparison operation, the number of values on either side did not match.
Action Match the lengths of tuples on both sides of the comparison.
11025: Data is too long for the column.
Cause The data length is too long for the column.
Action Shorten the data length.
11026: Data is too long to be converted to CHAR/VARCHAR/RAW data type.
Cause The data length exceeds the allowed length of a RAW, CHAR or VARCHAR type.
Action Modify the data length or change the data type.
11027: String is not in hexadecimal form.
Cause The string is not in hexadecimal form.
Action Check that the string correctly follows hexadecimal form.
11028: Parameter mismatch occurred in the user-defined function.
Cause Either the number of specified parameters does not match the required number or the omitted parameter is undefined.
Action Ensure the number of specified parameters is correct and the parameters are valid.
11029: No function matches the specified argument(s).
Cause No function matches the specified list of arguments.
Action Check the argument data type.
11030: Multiple functions match the specified argument(s).
Cause More than one function matches the specified list of arguments.
Action Check the argument data type.
11031: A function in the SQL statement has output parameter(s).
Cause Functions that have the output parameter(s) can only be call in a CALL statement.
Action Check the definition of the function.
11032: An invalid data type was returned by the PSM function.
Cause The return type of the PSM function is invalid.
Action Check that the return type of the PSM function can be processed in an SQL statement.
11033: Insufficient columns for update.
Cause The number of columns returned by the subquery in the UPDATE SET clause is insufficient.
Action Check the number of columns in the UPDATE SET clause.
11034: Too many columns for update.
Cause The number of columns returned by the subquery in the UPDATE SET clause is too large.
Action Check the number of columns in the UPDATE SET clause.
11035: Invalid NLS parameter exists in SQL function.
Cause An invalid NLS parameter exists in an SQL function.
Action Check the NLS parameter.
11036: Alias is required.
Cause An alias was not specified for a non-column expression.
Action Specify an alias.
11038: Percentile value must be between 0 and 1.
Cause The percentile value must be between 0 and 1.
Action Verify that the percentile is correct.
11039: Invalid SYS_CONTEXT namespace.
Cause The namespace is invalid for the SYS_CONTEXT function.
Action Ensure that the parameter of the function is USERENV.
11040: Invalid NLSSORT linguistic definition.
Cause The linguistic definition is invalid for the NLSSORT function.
Action Verify that the parameter is correct.
11041: Unsupported character set in regexp function.
Cause The character set is not supported in the regexp function.
Action Specify another character set.
11042: Invalid regular expression in regexp function.
Cause An invalid regular expression was used in the regexp function.
Action Correct the regular expression.
11043: Unsupported character set was described.
Cause The character set is not supported.
Action Check the character set.
11044: Invalid UNISTR argument.
Cause The UNISTR argument is invalid.
Action Check the UNISTR function.
11045: A function in the SQL statement has non-primitive type parameter(s).
Cause Functions that have the non-primitive parameter(s) can only be called from a CALL statement.
Action Check the definition of the function.
11046: A function in the SQL statement has non-primitive type parameter(s).
Cause Functions that have the non-primitive parameter(s) can only be called from a CALL statement.
Action Check the definition of the function.
11047: Bind parameter or expression is not allowed in the given position.
Cause A bind parameter or expression cannot be used in the given position.
Action Use a constant(number or string literal).
11048: \"%1$s\".\"%2$s\".\"%3$s\" The value is too large for the column. (Actual value: %4$d, Maximum value: %5$d)
Cause The data length is not appropriate for the column.
Action Shorten the data length.
11050: The length of the source document used in the regular ex pression function is too long.
Cause The length of the source document used in the regular expression function is too long.
Action Check the value of iparam_EX_REGEXP_CLOB_MAX_LEN.
11051: The length of the result returned by the REGEXP_REPLACE function is too long.
Cause The length of the result returned by the REGEXP_REPLACE function is too long.
Action Check the query.
11052: The object cannot be updated or inserted as NULL.
Cause The value of an object in an object table or a nested table cannot be NULL.
Action Check the query.
11053: The file name specified for With Materialization is invalid.
Cause The specified file cannot be created.
Action Check the file name.
11054: The input type is invalid.
Cause This data type cannot be used when the method is invoked using a call statement.
Action Check how the method was invoked, and that you are not using a psm data type as a parameter.
11055: The output format is invalid.
Cause The output format does not comply with the format rule.
Action Check the output format.
11056: The mask character is too long.
Cause The mask character must be in one character.
Action Check if the mask character has more than one character.
11057: The input column data have inconsistent lengths.
Cause The input column data must have consistent length.
Action Check if the input column data have consistent length.
11058: The input format is invalid.
Cause The input format must consist of 'V' or 'F'.
Action Check if the input format has characters other than 'V' or 'F'.
11059: This character set conversion is not supported.
Cause The CONVERT function does not support conversion between the two character sets.
Action Use a character set that is supported by the CONVERT function.
11060: JSON Document is invalid.
Cause JSON Document is does not comply with the JSON syntax.
Action Check the JSON document.
11061: JSONPath is invalid.
Cause JSONPath is does not comply with the JSONPath syntax.
Action Check the JSONPath.
11062: JSON Function Error.
Cause An error occurred in JSON Function.
Action Check the JSON function arguments.
11063: The number of elements exceeds the maximum varray size allocated to varray.
Cause Cannot insert an element in excess of the maximum varray size.
Action Modify the query to insert fewer elements than the varray size.
11064: Cycle mark and non-cycle mark values must be one-byte character string values.
Cause The cycle mark or non-cycle mark values specified in the CYCLE clause of a recursive WITH query are not one-byte character string values.
Action Specify a one-byte character string for the cycle mark and non-cycle mark values.
11065: The output value is too large (Actual value: %1$d, Maximum value: %2$d)
Cause The data length is not appropriate for the output type length.
Action Increase the data length.
Last updated