OBE-01000 ~ OBE-01499

OBE-01000: maximum open %s exceeded

• OceanBase error code: 5930

• SQLSTATE: HY000

• Cause: The maximum number of open cursors is exceeded.

OBE-01001: invalid cursor

• OceanBase error code: 5844

• SQLSTATE: HY000

• Cause: The cursor is invalid.

OBE-01002: fetch out of sequence

• OceanBase error code: 5931

• SQLSTATE: HY000

• Cause: An attempt was made to access data from an invalid cursor. This error can occur for the following reasons:

  • Accessing data from the cursor after retrieving the last row and returning the OBE-1403 error.

  • Accessing data after issuing a COMMIT following the use of a cursor opened with the FOR UPDATE clause.

  • Rebinding all placeholders in an SQL statement and then attempting to access data before re-executing the statement.

  Note

  Implicit fetches in PL cursor loops can also cause this error.

• Solution:

  • Do not issue a FETCH statement after retrieving the last row.

  • Do not access data after issuing a COMMIT following a cursor opened with the FOR UPDATE clause.

  • Rebind and execute the SQL statement, then attempt to access data.

OBE-01003: no statement parsed

• OceanBase error code: 9678

• SQLSTATE: HY000

• Cause: DBMS_SQL PARSE attempted to parse a DDL statement.

• Solution: Change the statement type of DBMS_SQL PARSE to a SELECT statement.

OBE-01006: bind variable does not exist

• OceanBase error codes: 5979, 9685

• SQLSTATE: HY000

• Cause: The bound variable does not exist.

• Solution: Bind a defined variable.

OBE-01007: variable not in select list

• OceanBase error code: 9745
• SQLSTATE: HY000
• Cause: The variable is not in the select list.
• Solution: Check whether the input SQL statement is correct.

OBE-01008: not all variables bound

• OceanBase error codes: 5857, 5978

• SQLSTATE: HY000

• Cause: Some variables are not configured.

OBE-01012: not logged on

• OceanBase error code: 5846

• SQLSTATE: HY000

• Cause: Not logged on.

OBE-01017: invalid username/password; logon denied

• OceanBase error code: 5845

• SQLSTATE: HY000

• Cause: The username/password is invalid. Logon is denied.

OBE-01031: insufficient privileges

• OceanBase error code: 5360

• SQLSTATE: HY000

• Cause: You do not have the required privileges to perform the database operation.

• Solution: Contact the database administrator or the designated security administrator to grant you the required privileges.

OBE-01045: user %.*s lacks %.*s privilege; login denied

• OceanBase error code: 5361

• SQLSTATE: HY000

• Cause: The user lacks the required privilege (usually CREATE SESSION) when attempting to log in. Logon is denied.

• Solution: Grant the corresponding privilege to the user. For example, to grant the CREATE SESSION privilege:

  GRANT CREATE SESSION TO username;
  

OBE-01086: savepoint does not exist

• OceanBase error code: 6242

• SQLSTATE: 42000

• Cause: You attempted to roll back to a savepoint that was never established or is invalid in the current session.

• Solution: Try rolling back to the savepoint from the session that established it.

OBE-01092: OceanBase instance terminated. Disconnection forced

• OceanBase error code: 5066

• SQLSTATE: HY000

• Cause: The session to which this process is connected has been abnormally terminated.

• Solution: For details, check the alert logs. Then restart the session.

OBE-01400: cannot insert NULL into '(%.*s)'

• OceanBase error code: 4235

• SQLSTATE: 23000

• Cause: You attempted to insert a NULL value into one of the preceding objects, but these objects do not accept NULL values.

OBE-01400: cannot insert NULL into (%.*s)

• OceanBase error code: 5030

• SQLSTATE: 42000

• Cause: You attempted to insert NULL into existing objects that do not accept NULL values.

OBE-01402: view WITH CHECK OPTION where-clause violation

• OceanBase error code: 5971

• SQLSTATE: HY000

• Cause: A DML operation on the view violates the view's WITH CHECK OPTION constraint.

• Solution: The data inserted into the view by an INSERT statement, or the data after an UPDATE, must satisfy the WHERE condition defined in the view.

OBE-01403: no data found

• OceanBase error code: 4026

• SQLSTATE: 02000

• Cause: No data was found in the object.

• Solution: No data is available from the object, possibly because data extraction has ended.

OBE-01405: fetched column value is NULL

• OceanBase error code: 5958

• SQLSTATE: HY000

• Cause: elem_count was set to NULL during an ANYTYPE SETINFO stored procedure call.

• Solution: Prohibit setting elem_count to NULL.

OBE-01408: such column list already indexed

• OceanBase error code: 5672

• SQLSTATE: HY000

• Cause: Such a list is already indexed.

OBE-01410: invalid ROWID

• OceanBase error code: 5802

• SQLSTATE: HY000

• Cause: Invalid ROWID.

OBE-01416: two tables cannot be outer-joined to each other

• OceanBase error code: 5620

• SQLSTATE: HY000

• Cause: Two tables cannot be outer joined to each other.

OBE-01418: specified index does not exist

• OceanBase error code: 5209

• SQLSTATE: 42000

• Error cause: The specified index does not exist.

OBE-01422: exact fetch returns more than requested number of rows

• OceanBase error code: 5294

• SQLSTATE: 42000

• Error cause: The number specified in exact fetch is less than the number of rows returned.

• Solution: Rewrite the query or change the requested number of rows.

OBE-01424: missing or illegal character following the escape character

• OceanBase error code: 5665

• SQLSTATE: HY000

• Error cause: The character following an escape character in a LIKE pattern is missing or is not a percent sign (%) or an underscore (_).

• Solution: Remove the escape character or specify the missing character.

OBE-01425: escape character must be character string of length 1

• OceanBase error code: 5666

• SQLSTATE: HY000

• Error cause: The escape character in a LIKE pattern is not a string of length 1.

• Solution: Change it to a string of length 1.

OBE-01426: numeric overflow, value larger than specified precision(%ld,%ld) allowed for this column

• OceanBase error code: 5088

• SQLSTATE: 22003

• Cause: The computation of the value expression results in an overflow or underflow.

• Solution: Reduce the operands.

OBE-01426: numeric overflow, value(%s) larger than specified precision(%ld,%ld) allowed for this column

• OceanBase error code: 5089

• SQLSTATE: 22003

• Cause: The computation of the value expression results in an overflow or underflow.

• Solution: Reduce the operands.

OBE-01426: numeric overflow

• OceanBase error code: 5093

• SQLSTATE: 22003

• Cause: The computation of the value expression results in an overflow or underflow.

• Solution: Reduce the operands.

OBE-01427: single-row subquery returns more than one row

• OceanBase error code: 5615

• SQLSTATE: HY000

• Cause: A single-row subquery returns multiple rows.

OBE-01427: single-row subquery returns more than one row

• OceanBase error code: 5153

• SQLSTATE: 21000

• Cause: A single-row subquery returns multiple rows.

OBE-01428: argument '%ld' is out of range

• OceanBase error code: 5674

• SQLSTATE: HY000

• Error cause: The parameter is out of range.

OBE-01436: CONNECT BY loop in user data

• OceanBase error code: 5764

• SQL STATE: HY000

• Error cause: A CONNECT BY loop exists in the user data.

OBE-01437: cannot have join with CONNECT BY

• OceanBase error code: 5765

• SQLSTATE: HY000

• Error cause: Joins are not allowed with CONNECT BY.

OBE-01438: value larger than specified precision allowed for this column '%.*s' at row %ld

• OceanBase error code: 4224

• SQLSTATE: 22003

• Error cause: When inserting or updating a record, the input value exceeds the precision of the column.

• Solution: Enter a value that matches the precision of the numeric column, or use the MODIFY option of the ALTER TABLE command to increase the column precision.

OBE-01441: cannot decrease column length because some value is too big

• OceanBase error code: 5897

• SQLSTATE: HY000

• Error cause: The column length cannot be decreased because some values are too large.

OBE-01442: column to be modified to NOT NULL is already NOT NULL

• OceanBase error code: 5849

• SQLSTATE: HY000

• Error cause: The column to be changed to NOT NULL is already NOT NULL.

OBE-01445: cannot select ROWID from, or sample, a join view without a key-preserved table

• OceanBase error code: 5902

• SQLSTATE: HY000

• Cause: You cannot query the ROWID from a join view or sample it without a key-preserved table.

OBE-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc

• OceanBase error code: 5903

• SQLSTATE: HY000

• Cause: You cannot query the ROWID from a view that has DISTINCT or GROUP BY clauses.

OBE-01450: maximum key length (%ld) exceeded

• OceanBase error code: 5196

• SQLSTATE: 42000

• Cause: The key length exceeds the maximum allowed.

OBE-01451: column to be modified to NULL cannot be modified to NULL

• OceanBase error code: 5850

• SQLSTATE: HY000

• Cause: The column may already allow NULL values, and the NOT NULL constraint is part of the primary key or a CHECK constraint.

• Solution: If the primary key or a CHECK constraint enforces the NOT NULL constraint, remove that constraint.

OBE-01453: SET TRANSACTION must be first statement of transaction

• OceanBase error code: 5219

• SQLSTATE: 25001

• Cause: Transaction characteristics cannot be changed while a transaction is in progress.

• Solution: Commit (or roll back) the transaction, then re-execute the modification.

OBE-01456: may not perform insert/delete/update operation inside a READ ONLY transaction

• OceanBase error code: 5220, 6226

• SQLSTATE: 25006

• Error cause: You cannot perform INSERT, DELETE, or UPDATE operations in a read-only transaction.

• Solution: Commit (or roll back) the transaction and try again.

OBE-01463: cannot modify column datatype with current constraint(s)

• OceanBase error code: 5860

• SQLSTATE: HY000

• Error cause: You are trying to modify the data type of a column with a CHECK constraint. However, for a column with a CHECK constraint, you can only change its data type from CHAR to VARCHAR.

• Solution: Drop the constraint or do not perform the invalid operation.

OBE-01465: invalid hex number

• OceanBase error code: 5342

• SQLSTATE: HY000

• Error cause: The provided value is an invalid hexadecimal number.

OBE-01466: Unable to read data -* Table definition has changed

• OceanBase error code: 5386
• SQLSTATE: HY000
• Error cause: The table definition has changed, and the snapshot point used for reading is too old, making it impossible to read or parse correctly.
• Solution: Check if the table definition has changed, and confirm whether there have been any additions or deletions of columns, or modifications to data types or lengths.

OBE-01468: a predicate may reference only one outer-joined table

• OceanBase error code: 5621

• SQLSTATE: HY000

• Error cause: A predicate can reference only one outer-joined table.

OBE-01476: divisor is equal to zero

• OceanBase error code: 4333

• SQLSTATE:HY000

• Error cause: The divisor is zero.

OBE-01481: invalid number format model

• OceanBase error code: 5606

• SQLSTATE:42000

• Error cause: An invalid numeric format was used when attempting to convert a number to a string using TO_CHAR or convert a string to a number using TO_NUMBER.

• Solution: For details about numeric formatting, see the Overview of format models section in the official documentation "SQL Reference (Oracle-compatible mode)".

OBE-01481: invalid number format model

• OceanBase error code: 5608

• SQLSTATE:42000

• Error cause: An invalid numeric format was used when attempting to convert a number to a string using TO_CHAR or convert a string to a number using TO_NUMBER.

• Solution: For details about numeric formatting, see the Overview of format models section in the official documentation "SQL Reference (Oracle-compatible mode)".

OBE-01482: unsupported character set

• OceanBase error code: 5937

• SQLSTATE:42000

• Error cause: The character set used for the operation is not supported.

• Solution: Use a supported character set.

OBE-01489: result of string concatenation is too long

• OceanBase error code: 5348

• SQLSTATE:HY000

• Error cause: The result of the string concatenation exceeds the maximum value.

• Solution: Ensure that the string concatenation result is less than the maximum value.

OBE-01494: invalid SIZE specified

• OceanBase error code: 5959

• SQLSTATE: HY000

• Cause: The specified SIZE value for the histogram is out of range.

• Solution: Specify a SIZE value within the range of [1, 2048].