OBE-50000 to OBE-99999

OBE-53203: security violation

• OceanBase error code: 9793

• SQLSTATE: HY000

• Cause: Security violation.

• Solution: Check the configuration of the database security product.

OBE-54002: only pure functions can be specified in a virtual column expression

• OceanBase error code: 5906

• SQLSTATE: HY000

• Cause: The virtual column expression contains a function with an uncertain value.

• Solution: Rewrite the expression to reference only pure functions.

OBE-54003: specified data type is not supported for a virtual column

• OceanBase error code: 5893

• SQLSTATE: HY000

• Cause: Virtual columns support only scalar data types. The LONG, BLOB, REF, and BFILE data types are not supported.

• Solution: Specify a supported scalar data type for the expression column.

OBE-54004: resultant data type of virtual column is not supported

• OceanBase error code: 5401

• SQLSTATE: HY000

• Cause: The base expression's data type is not supported for a virtual column; only scalar data types are supported. The LONG, BLOB, REF, and BFILE data types are not supported.

• Solution: Specify a supported scalar data type for the virtual column's expression.

OBE-54013: INSERT operation disallowed on virtual columns

• OceanBase error code: 5290

• SQLSTATE: HY000

• Cause: An attempt was made to insert a value into a virtual column.

• Solution: Rerun the statement without providing a value for the virtual column.

OBE-54016: Invalid column expression was specified

• OceanBase error code: 5908

• SQLSTATE: HY000

• Cause: The virtual column expression is not a valid arithmetic expression. It may reference another column in the table.

• Solution: Modify the expression of the virtual column.

OBE-54017: UPDATE operation disallowed on virtual columns

• OceanBase error code: 5907

• SQLSTATE: HY000

• Cause: An attempt was made to update the value of a virtual column.

• Solution: Rerun the statement without setting the value for the virtual column.

OBE-54021: Cannot use PL/SQL expressions in partitioning or subpartitioning columns

• OceanBase error code: 5995

• SQLSTATE: HY000

• Cause: A table is partitioned on a virtual column that contains a PL/SQL expression.

OBE-54023: Virtual column expression cannot be changed because a constraint is defined on column

• OceanBase error code: 5948

• SQLSTATE: HY000

• Cause: The value of a virtual column cannot be modified within a trigger body.

• Solution: Do not modify the value of a virtual column in a trigger.

OBE-54025: Virtual column cannot have a default value

• OceanBase error code: 5504
• SQLSTATE: HY000
• Cause: A virtual column cannot have a default value.
• Solution: Remove the default value from the virtual column.

OBE-54026: Real column cannot have an expression

• OceanBase error code: 5505
• SQLSTATE: HY000
• Cause: A real column cannot contain an expression.
• Solution: Remove the expression from the real column.

OBE-54027: cannot modify data-type of virtual column

• OceanBase error code: 5506
• SQLSTATE: HY000
• Cause: The data type of a virtual column cannot be modified.

OBE-54029: Virtual column cannot be updated in trigger body

• OceanBase error code: 9703

• SQLSTATE: HY000

• Cause: The value of a virtual column cannot be changed in the trigger body.

• Solution: This operation is invalid. You need to modify the trigger definition.

OBE-54036: cannot define referential constraint with ON DELETE SET NULL clause on virtual column

• OceanBase error code: 5513
• SQLSTATE: HY000
• Cause: A foreign key constraint with the ON DELETE SET NULL clause cannot be defined on a virtual column.
• Solution: Do not define a foreign key constraint with the ON DELETE SET NULL clause on a virtual column.

OBE-54037: table must have at least 1 column that is not virtual

• OceanBase error code: 5904

• SQLSTATE: 42000

• Cause: You are trying to create a table that contains only virtual columns.

• Solution: Ensure the table to be created contains at least one non-virtual column.

OBE-54039: table must have at least one column that is not invisible

• OceanBase error code: 5679

• SQLSTATE: HY000

• Cause: You are trying to create or alter a table so that it contains only invisible columns.

• Solution: The table being created or altered must contain at least one visible column.

OBE-54042: Invisible column is not supported on this type of table

• OceanBase error code: 5680

• SQLSTATE: HY000

• Cause: You are trying to create an invisible column or change the visibility of a column, but the current table does not support invisible columns. Only heap and index organized tables (IOTs) support invisible columns.

• Solution: These columns are not supported. Please modify the DDL.

OBE-54046: Column visibility modifications cannot be combined with any other modified column DDL option

• OceanBase error code: 5681

• SQLSTATE: HY000

• Cause: You are trying to combine a column visibility modification with modifications to other column attributes.

• Solution: Place the column visibility modification in a separate DDL statement.

OBE-54048: Column expression modifications cannot be combined with any other column DDL operation

• OceanBase error code: 5947

• SQLSTATE: HY000

• Cause: An attempt was made to combine modifications to a list expression with other column operations.

• Solution: Separate the modification operations on the list expression into independent DDL statements.

OBE-54053: The visibility of a column from a table owned by a SYS user cannot be changed

• OceanBase error code: 5682

• SQLSTATE: HY000

• Cause: An attempt was made to change the visibility of a column in a table owned by the SYS user.

• Solution: Execute this DDL on a table that is not owned by the SYS user.

OBE-56901: non-constant expression is not allowed for pivot|unpivot values

• OceanBase error code: 5805

• SQLSTATE: HY000

• Cause: An attempt was made to use a non-constant expression as a pivot or unpivot value.

• Solution: Use a constant expression as the pivot or unpivot value.

OBE-56902: expect aggregate function inside pivot operation

• OceanBase error code: 5806

• SQLSTATE: HY000

• Cause: An attempt was made to use a non-aggregate expression within a pivot operation.

• Solution: Use an aggregate expression.

OBE-56713: insufficient Resource Manager privileges

• OceanBase error code: 4715

• SQLSTATE: HY000

• Cause: Insufficient privileges to operate on the resource manager.

• Solution: Execute the operation as the root user.

OBE-62550: Invalid SQL ROW LIMITING expression was specified

• OceanBase error code: 5831

• SQLSTATE: HY000

• Cause: The SQL ROW LIMITING expression contains components other than text, bound variables, related variables, or subqueries.

• Solution: Modify the SQL ROW LIMITING expression and retry the operation.

OBE-64601: duplicate RESTART specified

• OceanBase error code: 4382

• SQLSTATE: HY000

• Cause: A duplicate RESTART directive is specified in the ALTER SEQUENCE command.

• Solution: Remove the duplicate RESTART directive.

OBE-64403:Input cannot be null

• OceanBase error code: 5471
• SQLSTATE: 42000
• Cause: The input cannot be NULL.
• Solution: Provide an input parameter.