Chapter 11. 11000 ~ 11999

11001: Subquery returned a tuple where a scalar value was expected.

CauseMore than one column was returned by a subquery.
ActionCheck 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.

CauseA subquery expected to return a scalar value returned more than two rows.
ActionCheck the scalar subquery.

11003: Invalid function argument type.

CauseThe function argument type is invalid.
ActionCheck the declaration of the function.

11004: Invalid function argument.

CauseThe specified function argument is invalid.
ActionCheck the declaration of the function.

11005: Specified value '%1$s' is invalid for mathematical function argument(s).

CauseThe specified mathematical function argument is invalid.
ActionCheck the declaration of the function.

11006: Invalid USERENV parameter.

CauseThe input is invalid for the USERENV function parameter.
ActionEnsure 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.

CauseThe first parameter of the TRIM function contains more than one character.
ActionSpecify only one character for the first parameter.

11008: Escape character must be one character long.

CauseThe length of the escape character in the LIKE clause does not equal 1.
ActionSet a single character for the escape argument.

11009: Invalid use of escape character.

CauseInvalid use of escape character.
ActionThe 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.

CauseThe TO_CHAR format cannot be specified for this type.
ActionRemove the format from the function formula.

11011: TO_DATE format cannot be specified for this data type.

CauseThe TO_DATE format cannot be specified for this type.
ActionRemove the format from the function formula.

11012: TO_TIME format cannot be specified for this data type.

CauseThe TO_TIME format cannot be specified for this type.
ActionRemove the format from the function formula.

11013: TO_TIMESTAMP format cannot be specified for this data type.

CauseThe TO_TIMESTAMP format cannot be specified for this type.
ActionRemove the format from the function formula.

11014: TO_NUMBER format cannot be specified for this data type.

CauseThe TO_NUMBER format cannot be specified for this type.
ActionRemove the format from the function formula.

11015: Input parameter string is too long.

CausePart of the input parameter string was too long.
ActionShorten the length of the string.

11016: Unsupported multi-byte character set in CLOB.

CauseAn attempt was made to use a CLOB with a multi-byte character set.
ActionUse single-byte character sets, or do not use a CLOB.

11017: The relational operator accepts only boolean values.

CauseA non-boolean operand was specified for the relational operator.
ActionVerify that the operand is a boolean operand.

11018: Operator does not accept operands of the given data type.

CauseThe operand type is invalid.
ActionInput a valid operand type for the operator.

11019: Concatenation applied to invalid data type.

CauseThe CONCAT operation may not be used on this data type.
ActionUse 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.

CauseThe result of a string concatenation is too long.
ActionMake sure that the total length of the concatenation result 4,000).

11021: Error occurred during type casting.

CauseAn attempt was made to convert the data type to an invalid data type.
ActionCheck the specified data type.

11022: Values are from incompatible data types.

CauseThe values are from incompatible data types.
ActionModify the data types to be compatible.

11023: Values are from data types that cannot be compared.

CauseThe values are from incomparable data types.
ActionModify the data types to be comparable.

11024: Cardinality mismatch found during group comparison.

CauseDuring a group comparison operation, the number of values on either side did not match.
ActionMatch the lengths of tuples on both sides of the comparison.

11025: Data is too long for the column.

CauseThe data length is too long for the column.
ActionShorten the data length.

11026: Data is too long to be converted to CHAR/VARCHAR/RAW data type.

CauseThe data length exceeds the allowed length of a RAW, CHAR or VARCHAR type.
ActionModify the data length or change the data type.

11027: String is not in hexadecimal form.

CauseThe string is not in hexadecimal form.
ActionCheck that the string correctly follows hexadecimal form.

11028: Parameter mismatch occurred in the user-defined function.

CauseEither the number of specified parameters does not match the required number or the omitted parameter is undefined.
ActionEnsure the number of specified parameters is correct and the parameters are valid.

11029: No function matches the specified argument(s).

CauseNo function matches the specified list of arguments.
ActionCheck the argument data type.

11030: Multiple functions match the specified argument(s).

CauseMore than one function matches the specified list of arguments.
ActionCheck the argument data type.

11031: A function in the SQL statement has output parameter(s).

CauseFunctions that have the output parameter(s) can only be call in a CALL statement.
ActionCheck the definition of the function.

11032: An invalid data type was returned by the PSM function.

CauseThe return type of the PSM function is invalid.
ActionCheck that the return type of the PSM function can be processed in an SQL statement.

11033: Insufficient columns for update.

CauseThe number of columns returned by the subquery in the UPDATE SET clause is insufficient.
ActionCheck the number of columns in the UPDATE SET clause.

11034: Too many columns for update.

CauseThe number of columns returned by the subquery in the UPDATE SET clause is too large.
ActionCheck the number of columns in the UPDATE SET clause.

11035: Invalid NLS parameter exists in SQL function.

CauseAn invalid NLS parameter exists in an SQL function.
ActionCheck the NLS parameter.

11036: Alias is required.

CauseAn alias was not specified for a non-column expression.
ActionSpecify an alias.

11038: Percentile value must be between 0 and 1.

CauseThe percentile value must be between 0 and 1.
ActionVerify that the percentile is correct.

11039: Invalid SYS_CONTEXT namespace.

CauseThe namespace is invalid for the SYS_CONTEXT function.
ActionEnsure that the parameter of the function is USERENV.

11040: Invalid NLSSORT linguistic definition.

CauseThe linguistic definition is invalid for the NLSSORT function.
ActionVerify that the parameter is correct.

11041: Unsupported character set in regexp function.

CauseThe character set is not supported in the regexp function.
ActionSpecify another character set.

11042: Invalid regular expression in regexp function.

CauseAn invalid regular expression was used in the regexp function.
ActionCorrect the regular expression.

11043: Unsupported character set was described.

CauseThe character set is not supported.
ActionCheck the character set.

11044: Invalid UNISTR argument.

CauseThe UNISTR argument is invalid.
ActionCheck the UNISTR function.

11045: A function in the SQL statement has non-primitive type parameter(s).

CauseFunctions that have the non-primitive parameter(s) can only be called from a CALL statement.
ActionCheck the definition of the function.

11046: A function in the SQL statement has non-primitive type parameter(s).

CauseFunctions that have the non-primitive parameter(s) can only be called from a CALL statement.
ActionCheck the definition of the function.

11047: Bind parameter or expression is not allowed in the given position.

CauseA bind parameter or expression cannot be used in the given position.
ActionUse 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)

CauseThe data length is not appropriate for the column.
ActionShorten the data length.

11050: The length of the source document used in the regular expression function is too long.

CauseThe length of the source document used in the regular expression function is too long.
ActionCheck the value of iparam_EX_REGEXP_CLOB_MAX_LEN.

11051: The length of the result returned by the REGEXP_REPLACE function is too long.

CauseThe length of the result returned by the REGEXP_REPLACE function is too long.
ActionCheck the query.