22998, 30926, 38104, and 38105

2025-01-10 06:15:55  Updated

These error codes indicate BLOB and CLOB errors.

ERROR 22998 (HY000): CLOB or NCLOB in multibyte character set not supported

  • Error code in OceanBase Database:: 22998

  • Cause: SQL string functions do not support the CLOB and NCLOB data types.

  • Solution: Use functions in the DBMS_LOG package.

ERROR 30926 (HY000): unable to get a stable set of rows in the source tables

  • Error code in OceanBase Database:: 30926

  • Cause: A stable set of rows cannot be generated because the DML statement contains a nondeterministic WHERE clause.

  • Solution: Remove the nondeterministic clause and execute the DML statement again.

ERROR 38104 (HY000): Columns referenced in the ON Clause cannot be updated:'%.*s'.'%.*s'

  • Error code in OceanBase Database:: 38104

  • Cause: Columns in the ON clause cannot be updated.

ERROR 38105 (HY000): specified row no longer exists

  • Error code in OceanBase Database:: 38105

  • Cause: A row was deleted by another user before the operation was completed.

  • Solution: Perform the operation again to process the remaining rows.

Contact Us