ORA-05000 to ORA-10000

ORA-06500: PL/SQL: storage error

• Error code in OceanBase Database: 5842

• SQLSTATE: HY000

• Cause: The PL program cannot allocate other storage. The program may be out of control.

• Solution:

  1. Make sure that the PL program does not use additional memory.

  2. Release unused objects through programming. For example, set them to NULL.

  3. Increase the size of the available shared or process memory space if applicable.

ORA-06501: PL/SQL: program error

• Error code in OceanBase Database: 5840

• SQLSTATE: HY000

• Cause: An internal error occurred. An error was detected in the PL program.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ORA-06502: PL/SQL: numeric or value error: %.*s

• Error code in OceanBase Database: 5677

• SQLSTATE: HY000

• Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, if you attempt to assign the NULL value to a variable that declares a NOT NULL constraint, or assign a value greater than 99 to a variable that declares NUMBER(2), this error is reported.

• Solution: Modify the data, the data calculation method, or the data declaration method so that the value does not violate the constraint.

ORA-06504: PL/SQL: Return types of Result Set variables or query do not match

• Error code in OceanBase Database: 5841

• SQLSTATE: HY000

• Cause: The number or type of columns in the query does not match the return types declared by result set variables, or the types declared by two result set variables do not match.

• Solution: Modify the program statement or declaration. Identify the query referenced by variables during execution.

ORA-06508: PL/SQL: could not find program unit being called: '%.*s'

• Error code in OceanBase Database: 5933

• SQLSTATE: HY000

• Cause: The program unit is not found.

ORA-06519: active autonomous transaction detected and rolled back

• Error code in OceanBase Database: 5796

• SQLSTATE: HY000

• Cause: All active autonomous transactions in an autonomous PL block must be completed (committed or rolled back) before they return from the block. If these transactions are not completed, the active autonomous transactions are implicitly rolled back, thereby inducing this error.

• Solution: Make sure that all active autonomous transactions are explicitly specified or rolled back before they return from the autonomous PL block.

ORA-06530: Reference to uninitialized composite

• Error code in OceanBase Database: 5837

• SQLSTATE: HY000

• Cause: An object, large object, or another composite object (such as a nested table or a record) that is not initialized is referenced on the left side.

• Solution: Initialize the composite object by using a proper constructor or through global object assignment.

ORA-06531: Reference to uninitialized collection

• Error code in OceanBase Database: 5838

• SQLSTATE: HY000

• Cause: A nested table, VARRAY element, or Member function is referenced, which requires an initialized collection, but the collection is not initialized.

• Solution: Initialize the collection by using an appropriate constructor or through global object assignment.

ORA-06532: Subscript outside of limit

• Error code in OceanBase Database: 5843

• SQLSTATE: HY000

• Cause: The subscript exceeds the upper limit for a VARRAY array, or the subscript is a non-positive value of a VARRAY array or nested table.

• Solution: Check the program logic and increase the upper limit for a VARRAY array if necessary.

ORA-06533: Subscript beyond count

• Error code in OceanBase Database: 5828

• SQLSTATE: HY000

• Cause: The subscript exceeds the maximum length of the VARRAY or is too large for the nested table.

• Solution: Check the logic of the program, and extend the logic explicitly if necessary.

ORA-06548: no more rows needed

• Error code in OceanBase Database: 5839

• SQLSTATE: HY000

• Cause: The caller of the pipelined function does not require the pipelined function to generate more rows.

• Solution: Do not handle the NO_DATA_NEEDED exception in an exception handling block.

ORA-06553: wrong number or types of arguments in call to '%.*s'

• Error code in OceanBase Database: 5343

• SQLSTATE: 42000

• Cause: SQL statement compilation failed due to the invalid reference of a PL unit.

• Solution: If the PLS error message does not provide a solution, try to execute the SQL statement as a top-level call.

  Note

  The operator must have the required privilege.

ORA-06562: type of out argument must match type of column or bind variable at '%.*s'

• Error code in OceanBase Database: 9568

• SQLSTATE: HY000

• Cause: The LONG type is specified for the column_value_long and define_value_long functions, which is not allowed.

• Solution: Specify supported argument types for the column_value_long and define_value_long functions.

ORA-07452: specified resource manager plan does not exist in the data dictionary

• Error code in OceanBase Database: 4718

• SQLSTATE: HY000

• Cause: You attempted to load a nonexistent resource manager plan.

• Solution: Use a resource manager plan that exists in the data dictionary.

ORA-08004: sequence exceeds %s and cannot be instantiated

• OceanBase error code: 4332

• SQLSTATE: HY000

• Cause: Instantiating Nextval would violate either MAXVALUE or MINVALUE.

• Solution: Change the sequence so that new values can be requested.

ORA-08006: specified row no longer exists

• OceanBase error code: 38105

• SQLSTATE: HY000

• Cause: Other users have deleted this row since the operation begins.

• Solution: Retry this operation.

ORA-08177: can't serialize access for this transaction

• Error code in OceanBase Database: 6235

• SQLSTATE: 25000

• Cause: Data modification is performed after a serializable transaction begins.

• Solution: Retry this operation in a read/write transaction.

ORA-08186: invalid timestamp

• OceanBase error code: 4344

• SQL STATE: HY000

• Cause: The timestamp is invalid. If you are using a flashback query, this error may be caused because OceanBase Database has performed a minor compaction after the specified flashback point in time.

• Solution: Enter a valid timestamp.

ORA-08187: snapshot expression not allowed here

• OceanBase error code: 32491

• SQL STATE: HY000

• Cause: The specified AS OF snapshot expression is not supported here.

• Solution: Do not use the AS OF clause.