No. 8000 ~ 8999
8002: Invalid DML statement.
Cause The statement is not a valid DML (Data Manipulation Language) statement.
Action Check the syntax.
8003: Unable to execute DML statement.
Cause Unable to execute the DML statement.
Action Check if DML is executable in the current DB state.
8004: Syntax error.
Cause There is a syntax error.
Action Check the statement syntax.
8005: Identifier is too long.
Cause The identifier is too long.
Action Adjust the length to less than 30 characters.
8006: Missing FROM keyword.
Cause The FROM keyword is missing.
Action Check the statement syntax.
8007: Missing boolean expression.
Cause A conditional expression is missing or contains syntax errors.
Action Check the statement syntax.
8008: Missing expression.
Cause Invalid or missing expression.
Action Check the expression syntax.
8009: Missing keyword.
Cause There is a syntax error.
Action Check the statement syntax.
8010: Missing INTO keyword.
Cause INTO keyword is missing.
Action Check the statement syntax.
8011: Missing VALUES keyword.
Cause VALUES keyword is missing.
Action Check the statement syntax.
8012: Missing comma.
Cause A comma is missing.
Action Check the statement syntax.
8013: Missing SELECT keyword.
Cause SELECT keyword is missing.
Action Check the statement syntax.
8014: Missing NULL keyword.
Cause NULL keyword is missing.
Action Check the statement syntax.
8015: Missing right parenthesis.
Cause Right parenthesis is missing.
Action Check the statement syntax.
8016: Missing BY keyword.
Cause BY keyword is missing after the ORDER, GROUP or CONNECT keyword.
Action Check the statement syntax.
8017: Missing CONNECT BY clause.
Cause In a hierarchical query, the CONNECT BY clause should be specified.
Action Check the statement syntax.
8018: Missing equal sign.
Cause In a SET clause, an \"=\" is missing.
Action Check the statement syntax.
8019: Missing WITH keyword.
Cause WITH keyword is missing after a START keyword.
Action Check the statement syntax.
8020: Missing SET keyword.
Cause In an UPDATE statement, a SET clause is missing.
Action Check the statement syntax.
8021: Invalid table name.
Cause The specification of the table, view or inline view in the FROM clause uses invalid syntax.
Action Check the statement syntax.
8022: Invalid end of SQL.
Cause The SQL statement is invalid.
Action Check the statement syntax.
8023: Invalid qualifier specification.
Cause Invalid qualifier specification.
Action Check the qualifier syntax.
8024: Duplicate derived column name exists.
Cause A derived column with this name already exists.
Action Rename the column.
8025: Number of derived columns and table columns do not match.
Cause The number of derived columns does not match the number of columns in a base table, view or inline view.
Action Modify the query.
8026: Invalid identifier.
Cause Unable to interpret the column or identifier.
Action Check the identifier.
8027: Column name is ambiguous.
Cause Columns with the same name exist in more than one table, view or inline view.
Action Specify a qualifier for the column name.
8028: FOR UPDATE clause is not allowed here.
Cause The FOR UPDATE clause was used in a SELECT query block other than the top one.
Action Check the query block syntax.
8029: FOR UPDATE clause is not allowed for this query.
Cause The FOR UPDATE statement cannot be used in a query that uses GROUP BY, DISTINCTor set functions.
Action Modify the query.
8030: Not enough values.
Cause The number of expressions specified in a VALUE statement is less than the number of columns.
Action Ensure that the numbers match.
8031: Too many values.
Cause The number of expressions specified in a VALUE statement is greater than the number of columns.
Action Ensure that the numbers match.
8032: ORDER BY position must be the same as an entry number in a SELECT-list expression.
Cause The position specified in ORDER BY clause is out of range.
Action Specify a valid position.
8033: Specified schema object was not found.
Cause The specified schema object does not exist.
Action Check the schema object name.
8034: Specified sequence was not found.
Cause The sequence does not exist.
Action Check the sequence name.
8035: Specified synonym was not found.
Cause The synonym does not exist.
Action Check the synonym name.
8036: Specified procedure or function was not found.
Cause Procedure or function does not exist.
Action Check the procedure name.
8037: Invalid use of group functions.
Cause Set functions cannot be used in SELECT LIST, HAVING, or ORDER BY clauses.
Action Check the statement syntax.
8038: Expression is not in a GROUP BY clause.
Cause An expression that was not specified in a GROUP BY clause was used.
Action Modify the query.
8039: The ORDER BY clause must contain constants or SELECT list expressions.
Cause When DISTINCT is specified in a SELECT LIST clause, it must be used in an ORDER BY clause.
Action Modify the query.
8040: Duplicate column name exists.
Cause A column name is used more than once.
Action Modify the query.
8041: Invalid table reference.
Cause In a FROM clause, schema objects other than tables and views cannot be used.
Action Modify the query.
8042: Outer join operator (+) cannot be used in a clause with a subquery.
Cause Sub queries cannot be used along with the outer join condition.
Action Modify the query.
8043: Outer join operator (+) cannot be used in a clause with OR.
Cause The OR operator cannot be used along with the outer join condition.
Action Modify the query.
8044: Outer join operator (+) cannot be used in a clause with IN.
Cause The IN operator cannot be used along with the outer join condition.
Action Modify the query.
8045: Outer join operator (+) cannot be used on both sides simul taneously.
Cause Outer joining of two tables is not allowed.
Action Delete one of the outer join conditions.
8046: Outer join operator (+) cannot be used between more than two tables.
Cause Outer joining between more than two tables is not allowed.
Action Modify the query.
8047: Outer join operator (+) cannot be used with ANSI joins.
Cause Outer joins cannot be used with ANSI joins.
Action Modify the query.
8048: Virtual table (dynamic performance view) cannot be updated.
Cause An attempt was made to update virtual table.
Action Virtual table cannot be updated.
8049: The ORDER BY clause in a SET clause is invalid: use ordinal numbers.
Cause In an ORDER BY clause in a query where SET the operator was used, invalid expressions were used.
Action Modify the query.
8050: Procedures are prohibited in the DML expression.
Cause Procedure cannot be used in DML statement.
Action Unable to use procedure.
8051: User-defined functions are not permitted in the expression.
Cause Functions cannot be used in a CALL clause which requires a procedure.
Action Use a valid procedure.
8052: Invalid object status.
Cause The current object is disabled.
Action Recreate the object.
8053: Not authorized.
Cause An attempt was made to access unauthorized objects or columns.
Action Unable to access the object.
8054: Subquery cannot be used in GROUP BY clause.
Cause Subquery cannot be used in GROUP BY clause.
Action Modify the query.
8055: The number of expressions in the RETURNING clause and the number of INTO columns do not match.
Cause The number of expressions specified in the RETURNING clause and that of columns to be updated do not match with each other.
Action Modify the query.
8056: Invalid number of columns in query.
Cause The number of PROJECTIONs between blocks used in SET operation do not match.
Action Modify the query.
8057: Columns are non-updatable.
Cause The column cannot be updated.
Action Check whether or not the column is in a key-preserved table.
8058: Too many key-preserved tables specified.
Cause More than two key-preserved tables cannot be updated at once.
Action Modify the query to update only one key preserved table.
8059: A key-preserved table was not found.
Cause The view cannot be updated.
Action Check whether or not it is a key-preserved table.
8060: A deletable table was not found.
Cause A key preserved table, which can be deleted, does not exist in view.
Action Check the definition of the view.
8061: Columns in USING clauses or NATURAL joins cannot have a qualifier.
Cause Columns in USING clauses or NATURAL joins cannot have a qualifier.
Action Delete the qualifier.
8062: Nesting level of aggregation functions is too deep.
Cause The nesting level of aggregation functions is too deep.
Action Modify the query.
8063: LONG columns are not permitted.
Cause LONG type columns cannot be used.
Action Modify the query.
8064: LOB columns are not permitted.
Cause LOB type columns cannot be used.
Action Modify the query.
8065: Invalid host variable name.
Cause An invalid host variable name was used.
Action Ensure the host variable name uses proper syntax.
8066: Circular view detected.
Cause View definition cannot reference itself.
Action Check the view definition.
8067: Invalid window value used in analytic clause.
Cause Invalid window range expression in analytic function.
Action Modify the query.
8068: ORDER BY cannot be used here.
Cause The ORDER BY clause cannot be used in a subquery.
Action Modify the query.
8069: Invalid single-group group function.
Cause Columns which are not used in a GROUP BY clause are used outside aggregation functions.
Action Change the query.
8070: Subqueries are not allowed in SELECT LIST clauses that use nested aggregation.
Cause SELECT LIST clauses that use the nested aggregation function cannot use subqueries.
Action Delete the subquery.
8071: Partition name cannot be used with view.
Cause View cannot use partition name.
Action Delete the partition name.
8072: Subqueries cannot be used in this clause.
Cause A subquery cannot be used in DEFAULT, CHECK or RETURNING clauses.
Action Delete the subquery.
8073: UDF cannot be used in this clause.
Cause UDF cannot be used in DEFAULT or CHECK clauses.
Action Modify the query.
8074: Sequence cannot be used here.
Cause Sequence being is used in an invalid position.
Action Modify the query.
8075: ROWNUM cannot be used in this clause.
Cause ROWNUM cannot be used in DEFAULT or CHECK clauses, or as a join condition.
Action Modify the query.
8076: LEVEL cannot be used in this clause.
Cause LEVEL cannot be used in DEFAULT or CHECK clauses.
Action Modify the query.
8077: Bind variable cannot be used in this clause.
Cause The bind variable cannot be used in DEFAULT or CHECK clauses.
Action Modify the query.
8078: Aggregation function cannot be used in this clause.
Cause The aggregation function cannot be used in DEFAULT or CHECK columns.
Action Modify the query.
8079: Analytic function cannot be used in this clause.
Cause The analytic function cannot be used in DEFAULT clauses, CHECK clauses, and in index columns.
Action Modify the query.
8080: PRIOR keyword cannot be used in this clause.
Cause PRIOR keyword can be used only in a CONNECT BY clause.
Action Modify the query.
8081: Column cannot be used in this clause.
Cause Column cannot be used in DEFAULT or VALUES clauses.
Action Modify the query.
8082: Non-deterministic functions, date or system variables cannot be used in this clause.
Cause Non-deterministic functions cannot be used in DEFAULT clauses, CHECK clauses, and in index columns.
Action Modify the query.
8083: Table is not partitioned.
Cause PARTITION or SUBPARTITION keywords cannot be used in non-partitioned tables.
Action Modify the query.
8084: The specified partition does not exist.
Cause Unable to find the partition name.
Action Check the partition name and retry.
8085: The specified sub-partition does not exist.
Cause Unable to find the sub-partition name.
Action Check the sub-partition name and retry.
8086: %1$s is not supported.
Cause The syntax is not supported by the current version.
Action Modify the query.
8087: Invalid SET clause.
Cause The expression in a SET clause is incomplete.
Action Correct the expression.
8088: View %1$s has errors.
Cause View definition, referenced schema object or authority check has errors.
Action Correct the error.
8089: Tuple expression must have a degree of 2.
Cause Invalid number of argument of the OVERLAP function.
Action Verify the use of the OVERLAP function.
8090: Invalid bind variable name.
Cause Bind variable names starting with ':SYS_B_' cannot be used.
Action Change the name.
8091: INSERT/UPDATE/DELETE cannot be performed on tables with constraints (%1$s.%2$s) in the DISABLE VALIDATE state.
Cause An attempt was made to execute INSERT/UPDATE/DELETE on a table with constraints in a DISABLE VALIDATE state.
Action Modify the constraints condition.
8092: SIBLINGS keyword cannot be used in this clause.
Cause SIBLINGS cannot be specified in the ORDER BY clause.
Action Modify the query.
8093: INTO clauses cannot be used here.
Cause INTO and BULK COLLECT INTO clauses can be specified only in the top query block.
Action Modify the query.
8094: LEVEL, PRIOR or ROWNUM keywords cannot be used here.
Cause LEVEL, PRIOR and ROWNUM keywords cannot be used with the PRIOR operator.
Action Modify the query.
8095: Percentage in a SAMPLE clause must be in the range [0.000001, 100).
Cause Percentage in a SAMPLE clause must be between 0.000001 and 100 (must be less than 100).
Action Modify the value to fall within the range.
8096: CONNECT_BY_ROOT operator cannot be used here.
Cause The CONNECT_BY_ROOT operator cannot be used here.
Action Modify the query.
8097: CONNECT_BY_ISLEAF operator cannot be used here.
Cause The CONNECT_BY_ISLEAF operator cannot be used here.
Action Modify the query.
8098: SYS_CONNECT_BY_PATH operator cannot be used here.
Cause The SYS_CONNECT_BY_PATH operator cannot be used here.
Action Modify the query.
8099: CONNECT_BY_ISCYCLE operator cannot be used here.
Cause The CONNECT_BY_ISCYCLE operator cannot be used here.
Action Modify the query.
8100: Target must be a table.
Cause Target of MERGE INTO statement must be a table.
Action Check the target object.
8101: Column used in the ON clause cannot be updated.
Cause The column used in an ON clause cannot be updated.
Action Modify the query.
8102: Outer join cannot be specified for a correlation column.
Cause An outer join cannot be specified for a correlation column.
Action Change the query.
8103: Circular synonym detected.
Cause Synonyms cannot reference themselves.
Action Check the definition of the synonym.
8104: DECODE function has too many arguments.
Cause More than 255 arguments were used.
Action Reduce the number of arguments in the DECODE function.
8105: The CASE function has too many arguments.
Cause More than 65535 arguments were used.
Action Reduce the number of arguments in the CASE function.
8106: Outer join operator may not be used in this clause.
Cause The outer join operator can only be used in ON and WHERE clauses.
Action Modify the query.
8107: Distributed operation is not supported.
Cause The MERGE statement attempted to process more than two DB instances.
Action Modify the query.
8108: Invalid relational operator.
Cause Invalid condition expression.
Action Modify the condition expression.
8109: Argument must be a constant expression.
Cause Only expressions with the same value in GROUP BY clauses are allowed.
Action Use only expressions which are used in a constant expression or GROUP BY clause.
8110: Too many WHEN clauses used.
Cause A single multitable insert statement contained more than 127 WHEN clauses.
Action Reduce the number of WHEN clauses in the statement.
8111: View or remote table cannot be the target of a multitable in sert.
Cause View or remote table cannot be the target of a multitable insert.
Action Modify the query.
8112: Reference cursor table has too many arguments.
Cause More than 10,000 arguments were used.
Action Reduce the number of arguments in the PSM function.
8113: Insufficient arguments specified for a function.
Cause An argument required for the function was omitted.
Action Specify the omitted argument again.
8114: Too many arguments specified for a function.
Cause The number of arguments specified for a function exceeds the number required.
Action Delete extraneous arguments.
8115: Flashback query clause is not valid here.
Cause The flashback query clause was used in an invalid location.
Action Modify the query.
8116: DISTINCT option cannot be used for this function.
Cause The DISTINCT option cannot be used for this function.
Action Delete the DISTINCT option and try again.
8117: Invalid datatype used in function.
Cause The datatype used in the function is invalid.
Action Check the arguments of the function.
8118: Unable to select rowid column from the index-organized table.
Cause Unable to select rowid column from the index-organized table.
Action Remove the rowid column and try again.
8119: Revalidation of trigger '%1$s' failed
Cause Failed to recompile the invalid trigger.
Action Modify the trigger source code and create again.
8120: A column '%1$s' for the error log table '%2$s' is missing.
Cause A column required for the error log table is is missing.
Action Check the error log table.
8121: Invalid number of arguments.
Cause The number of arguments is incorrect.
Action Check the syntax and change it.
8122: Internal hint cannot be used.
Cause Internal hint cannot be used.
Action Remove internal hint.
8124: The query defined in the RECURSIVE WITH clause is not valid.
Cause The query defined in the RECURSIVE WITH clause violates an integrity constraint.
Action Define the query in the format of (anchor member) UNION ALL (recursive member).
8125: A column alias list was not defined in the RECURSIVE WITH clause.
Cause Column name aliases were not defined for the query names.
Action Add a column alias list for the query names in the RECURSIVE WITH clause.
8126: There are statements that are not supported as a recursive member of the recursive WITH clause.
Cause The following statement cannot be used as a recursive member to the right of UNION ALL statement within the recursive WITH query: GROUP BY, HAVING, DISTINCT, CONNECT BY, window functions, set operations, and aggregate functions.
Action Rewrite the recursive WITH query so that the unsupported statements are not used.
8127: This join is not supported by the recursive WITH query.
Cause The recursive WITH clause contains the recursive query name at one of the following po sitions: the right side of the LEFT OUTER JOIN, the left side of the RIGHT OUTER JOIN, the FULL OUTER JOIN, or in the subquery.
Action Rewrite the query with the supported join.
8128: Read-only table cannot be updated.
Cause An attempt was made to execute DML on a read-only table.
Action Read-only table cannot be updated.
8129: Index by that name was not found.
Cause Unable to find the index name.
Action Check the index name and retry.
8130: Index is not partitioned.
Cause INDEX_PARTITION or INDEX_SUBPARTITION keywords cannot be used in non-partitioned indexes.
Action Modify the query.
8131: Circular RLS policy has been detected.
Cause The predicate returned by the policy function refers to the object that the policy is attached to.
Action Check the definition of the policy function.
8132: The policy predicate contains an error.
Cause The predicate string generated by the policy function is not valid for this object.
Action Check the definition of the policy function.
8133: Invalid use of association operator (=>).
Cause Association operator (=>) can only be used as an UDF argument.
Action Modify the query.
8134: A user-defined aggregate function can have only one param eter.
Cause Check the definition or the call of the user-defined aggregate function.
Action Modify the definition of the user-defined aggregate function and regenerate it.
8135: The '%1$s' interface function is undefined.
Cause Check the definition of the object type.
Action Modify the object type definition and regenerate it.
8136: The parameter of the user-defined aggregate function and the parameter of the 'TUDIAGGREGATEITERATE' function defined in the object type are not compatible.
Cause Check the query and the definition of the object type.
Action Modify the query or the definition of the object type and regenerate it.
8137: The result type of the object type and the result type of the user-defined aggregate function are not compatible.
Cause Check the query and the definition of the object type.
Action Modify the query or the definition of the object type and regenerate it.
8138: A single unique index must be specified in the index hint.
Cause An index was not specified in the IGNORE_ROW_ON_DUPKEY_INDEX hint.
Action Specify a unique index defined in the table.
8139: Index specified in the index hint is invalid.
Cause The unique index was not found.
Action Specify a unique index defined in the table.
8140: Multiple unique indexes were specified in the index hint.
Cause Multiple unique indexes were specified in the index hint.
Action Specify a single unique index.
8141: Argument must be a constant expression.
Cause The specified function argument is invalid.
Action Check the declaration of the function.
8142: This DML statement is not permitted in the current boot mode.
Cause In the current boot mode, this DML cannot be executed.
Action Change the boot mode and run the DML statement again.
8143: Cannot insert a value in a virtual column.
Cause Attempted to insert a value in a virtual column.
Action Write insert statements except for this column.
8144: Cannot update a value in a virtual column.
Cause Attempted to update a value in a virtual column.
Action Remove the SET clause for this column in UPDATE statements.
8145: The value set to AUTO_INCREMENT COLUMN in the insert statement is incorrect.
Cause A value other than null cannot be inserted into the AUTO_INCREMENT COLUMN.
Action Remove AUTO_INCREMENT COLUMN or set the AUTO_INCREMENT COLUMN to null in the insert statement.
8146: A WITH query name has been duplicated in a recursive node in a recursive WITH.
Cause Self reference can be used only once in a recursive node in a recursive WITH.
Action Rewrite the query so that a WITH query name can be used only once.
8147: Expressions that return a user-defined type is not allowed in the current context.
Cause Only expressions that return a built-in type are allowed in the current context.
Action Check the return type of the expression in the current context.
8148: Expression is not in a SUBQRY LIST clause.
Cause An expression that was not specified in a SUBQRY LIST clause was used.
Action Modify the query.
8149: An object table is required.
Cause This syntax expects an object table.
Action Check the table specified in the query.
8150: Invalid data type for the split key in the WITH clause.
Cause The specified type cannot be converted into a string type.
Action Modify the split key value in the WITH clause.
8151: Expression is not in a SUBQRY LIST clause.
Cause An expression that was not specified in a SUBQRY LIST clause was used.
Action Modify the query.
8152: Cannot specify a correlated column.
Cause A correlated column is not allowed in this context.
Action Modify the query.
8153: The cursor function was used incorrectly.
Cause A cursor function must be placed in the outer most select list or used as a psm argument.
Action Modify the query.
8154: User defined type columns are not permitted.
Cause User defined type type columns cannot be used.
Action Modify the query.
8155: Index or partition of such index is in unusable state.
Cause Index or partition of such index is in unusable state.
Action DROP the specified index, or REBUILD the specified index.
8156: Logical error in parser.
Cause
Action
8157: Data redaction does not support the specified SQL format.
Cause The query includes operations that are not supported by data redaction.
Action Modify the query.
8158: Permission denied due to redaction policy.
Cause The user has insufficient privileges on the redacted table.
Action Modify the query.
8159: Memory exhausted while parsing the query.
Cause Memory exhausted while parsing the query.
Action Increase the memory limit using _PARSE_ALLOWED_MEMORY_DEPTH.
8160: The type of value does not match the type of column.
Cause The type of value to insert cannot be converted into the type of column.
Action Check the type of column and value.
8161: Integer value required.
Cause The input value must be an integer.
Action Use an integer value expression as the input.
8162: Cannot insert into an always identity column.
Cause An attempt was made to insert a value into an identity column created with the GENERATED ALWAYS keywords.
Action A value cannot be inserted directly into an always identity column. The value must be generated by the associated sequence generator.
8163: Cannot update an always identity column.
Cause An attempt was made to update an identity column created with the GENERATED ALWAYS keywords.
Action An always identity column cannot be directly updated.
8164: Unable to convert data due to character set mismatch.
Cause Data conversion between Tibero instances with different character sets is not allowed.
Action Set both instances to the same character set.
8165: Invalid identifier '%1$s' .
Cause Unable to interpret the column or identifier.
Action Check the identifier.
8166: A partition name must be specified for a system partitioned table.
Cause The partition extended syntax was not used for the system partitioned table.
Action Use the partition extended syntax to specify the system partitioned table.
8167: The computed column length is too long.
Cause The column length calculated based on the source and target DB character sets is too long.
Action Check the target database's character set and the target column length.
8168: Table does not contain visible columns.
Cause A query was attempted on a table that does not contain any visible columns.
Action Retry the operation on a table with a visible column.
8169: Cannot find argument in expressions of PARTITION BY.
Cause The argument must be in the expressions of the PARTITION BY clause.
Action Check if the argument exists in the expressions of the PARTITION BY clause.
8170: '%1$s' argument is not function of expressions in PARTITION BY clause.
Cause The argument must be a function of expressions in PARTITION BY claue.
Action Check the argument.
8171: COLLECTION columns are not permitted.
Cause COLLECTION type columns cannot be used.
Action Modify the query.
8172: Elements in sort specification list of SEARCH clause must be found from the column alias list.
Cause Cannot find elements in sort specification list of SEARCH clause from the column alias list.
Action Change the sort specification list to use only names that are listed in the column alias list.
8173: An ordering column name for SEARCH clause must not be part of the column alias list.
Cause The ordering column name is already in use in the column alias list.
Action Specify a different name for the ordering column or change the name in the column alias list.
8174: Elements in cycle column list of CYCLE clause must be found from the column alias list.
Cause Cannot find elements in cycle column list of CYCLE clause from the column alias list.
Action Change the cycle column list to use only names that are listed in the column alias list.
8175: A cycle mark column name for CYCLE clause must not be part of the column alias list.
Cause The cycle mark column name is already in use in the column alias list.
Action Specify a different name for the cycle mark column or change the name in the column alias list.
8176: The ordering column for SEARCH clause must be different from the cycle mark column for CYCLE clause.
Cause The ordering column for SEARCH clause matches the cycle mark column for CYCLE clause.
Action Change either the ordering column or the cycle mark column so that they no longer match.
8177: The cycle value for CYCLE clause must be different from the non-cycle value.
Cause The cycle value for CYCLE clause is the same as the non-cycle value.
Action Change either the cycle or the non-cycle values so that they no longer match.
8178: SEARCH and CYCLE clauses can only be specified for recur sive WITH clause elements.
Cause A SEARCH or CYCLE clause is specified for a non-recursive WITH clause element.
Action Remove the SEARCH or CYCLE clause, or add recursion to the WITH clause element.
Last updated