ORA-50000 to ORA-99999

ORA-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 whose evaluation is non-deterministic.

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

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

• OceanBase error code: 5893

• SQLSTATE: HY000

• Cause: Only scalar data types are supported for virtual columns. LONG, BLOB, REF, and BFILE data types are not supported for virtual columns.

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

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

• OceanBase error code: 5401

• SQLSTATE: HY000

• Cause: The data type of the underlying expression is not supported. Only scalar data types are supported for virtual columns. LONG, BLOB, REF, and BFILE data types are not supported for virtual columns.

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

ORA-54013: INSERT operation disallowed on virtual columns

• OceanBase error code: 5290

• SQLSTATE: HY000

• Cause: You are attempting to insert values into a virtual column.

• Solution: Re-execute the statement without providing values for the virtual column.

ORA-54016: Invalid column expression was specified

• OceanBase error code: 5908

• SQLSTATE: HY000

• Cause: The virtual column expression is not a valid arithmetic expression. It probably refers to another column in the table.

• Solution: Change the expression of the virtual column.

ORA-54017: UPDATE operation disallowed on virtual columns

• OceanBase error code: 5907

• SQLSTATE: HY000

• Cause: You are attempting to update values of a virtual column.

• Solution: Re-execute the statement without setting values for the virtual column.

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

• OceanBase error code: 5995

• SQLSTATE: HY000

• Cause: You are attempting to partition a table on a virtual column that contained PL/SQL expressions.

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

• OceanBase error code: 5948

• SQLSTATE: HY000

• Cause: You are attempting to change the values of a virtual column in a trigger body.

• Solution: Do not change the values of virtual columns in triggers.

ORA-54025: Virtual column cannot have a default value

• OceanBase error code: 5504
• SQLSTATE: HY000
• Cause: A virtual column cannot contain default values.
• Solution: Remove default values from the virtual column.

ORA-54026: Real column cannot have an expression

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

ORA-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.

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

• OceanBase error code: 5703

• SQLSTATE: HY000

• Cause: You are attempting to change the values of a virtual column in a trigger body.

• Solution: The operation is invalid. You must change the trigger definition.

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

• OceanBase error code: 5513
• SQLSTATE: HY000
• Cause: You cannot define a FOREIGN KEY constraint with the ON DELETE SET NULL clause on a virtual column.
• Solution: Do not define FOREIGN KEY constraints with the ON DELETE SET NULL clause on virtual columns.

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

• OceanBase error code: 5904

• SQLSTATE: 42000

• Cause: You are attempting to create a table with only virtual columns.

• Solution: Create a table that contains at least one non-virtual column.

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

• OceanBase error code: 5679

• SQLSTATE: HY000

• Cause: You are attempting to create or modify a table to make it contain only invisible columns.

• Solution: Make sure that the table contains at least one visible column.

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

• OceanBase error code: 5680

• SQLSTATE: HY000

• Cause: You are attempting to create invisible columns or modify the visibility of columns, but the current table does not support invisible columns. Only heap tables and index organized tables (IOT) support invisible columns.

• Solution: Modify the DDL statement.

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

• OceanBase error code: 5681

• SQLSTATE: HY000

• Cause: You are attempting to combine a column visibility modification operation with other column attribute modification operations.

• Solution: Create an independent DDL statement for the column visibility modification operation.

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

• OceanBase error code: 5947

• SQLSTATE: HY000

• Cause: You are attempting to combine a column expression modification operation with other column operations.

• Solution: Create an independent DDL statement for the column expression modification operation.

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

• OceanBase error code: 5682

• SQLSTATE: HY000

• Cause: You are attempting to modify the visibility of columns in a table owned by the SYS user.

• Solution: Execute this DDL statement on tables not owned by the SYS user.

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

• OceanBase error code: 5805

• SQLSTATE: HY000

• Cause: You are attempting to use a non-constant expression for pivot and unpivot values.

• Solution: Use a constant expression for pivot and unpivot values.

ORA-56902: expect aggregate function inside pivot operation

• OceanBase error code: 5806

• SQLSTATE: HY000

• Cause: You are attempting to use non-aggregate expressions in pivot operations.

• Solution: Use aggregate expressions.

ORA-56713: insufficient Resource Manager privileges

• OceanBase error code: 4715

• SQLSTATE: HY000

• Cause: You do not have the Resource Manager privilege.

• Solution: Execute related operations as the root user.

ORA-62550: Invalid SQL ROW LIMITING expression was specified

• OceanBase error code: 5831

• SQLSTATE: HY000

• Cause: The ROW LIMITING expression of the SQL statement contains components other than literals, bind variables, correlation variables, or subqueries.

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

ORA-64601: duplicate RESTART specified

• OceanBase error code: 4382

• SQLSTATE: HY000

• Cause: You specified duplicate RESTART in the ALTER SEQUENCE command.

• Solution: Delete the duplicate RESTART.

ORA-64403: Input cannot be null

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