ORA-50000 to ORA-99999

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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5995

• SQLSTATE: HY000

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

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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

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

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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 4382

• SQLSTATE: HY000

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

• Solution: Delete the duplicate RESTART.

ORA-64403: Input cannot be null

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