9500 to 9999

These error codes indicate Procedural Language (PL) errors.

ERROR 9502 (HY000): OUT and IN/OUT modes cannot be used in this context

• Error code in OceanBase Database: 9502

• Cause: The OUT keyword can be used in a dynamic data manipulation language (DML) statement only when the statement contains the returning variable but not the INTO keyword.

• Solution: Check whether the current statement syntax supports the OUT keyword.

ERROR 9503 (HY000): object '%.*s' of type %.*s not found in schema '%.*s'

• Error code in OceanBase Database: 9503

• Cause: No object identified by the specified type and name exists.

• Solution: Specify a valid object type and a valid object name.

ERROR 9506 (HY000): Only schema-level programs allow %s

• Error code in OceanBase Database: 9506

• Cause: The INVOKER RIGHT clause can be defined only in a standalone procedure or function.

• Solution: Drop the INVOKER RIGHT clause.

ERROR 9507 (HY000): at most one declaration for '%.*s' is permitted

• Error code in OceanBase Database: 9507

• Cause: Duplicate identifiers exist in the same namespace.

• Solution: Make sure that identifiers in the same namespace are unique.

ERROR 9508 (HY000): duplicate fields in RECORD,TABLE or argument list are not permitted

• Error code in OceanBase Database: 9508

• Cause: Duplicate parameters are specified in PL statements.

• Solution: Make sure that parameters in PL statements are unique.

ERROR 9509 (HY000): Pragma AUTONOMOUS_TRANSACTION cannot be specified here

• Error code in OceanBase Database: 9509

• Cause: The current location of the autonomous transaction clause is not allowed. The clause can be placed only in a block at the first layer.

• Solution: Adjust the location of the autonomous transaction clause.

ERROR 9510 (HY000): illegal EXIT/CONTINUE statement; it must appear inside a loop

• Error code in OceanBase Database: 9510

• Cause: The EXIT or CONTINUE clause is not used inside a loop.

• Solution: Make sure that the EXIT or CONTINUE clause is used inside a loop.

ERROR 9512 (HY000): EXIT/CONTINUE label '%.*s' must label a LOOP statement

• Error code in OceanBase Database: 9512

• Cause: The destination label of the EXIT or CONTINUE clause is invalid.

• Solution: Make sure that the destination label of the EXIT or CONTINUE clause is valid.

ERROR 9513 (HY000): expression '%.*s' is inappropriate as the left hand side of an assignment statement

• Error code in OceanBase Database: 9513

• Cause: A static cursor cannot be used to assign a value.

• Solution: Make sure that the assignment statement is valid.

ERROR 9514 (HY000): a variable declared NOT NULL must have an initialization assignment

• Error code in OceanBase Database: 9514

• Cause: A variable with the NOT NULL constraint is not explicitly initialized.

• Solution: Remove the NOT NULL constraint or explicitly initialize the variable.

ERROR 9515 (HY000): Constant declarations should contain initialization assignments

• Error code in OceanBase Database: 9515

• Cause: A constant variable is not explicitly initialized.

• Solution: Remove the constant declaration or explicitly initialize the variable.

ERROR 9516 (HY000): Cursor Variables cannot be declared as part of a package

• Error code in OceanBase Database: 9516

• Cause: Cursor variables cannot be declared in a package.

ERROR 9518 (HY000): value in LIMIT clause: \'%.*s\' use is invalid

• Error code in OceanBase Database: 9518

• Cause: The data type of the expression in the LIMIT clause is invalid.

• Solution: Change the data type to a numeric data type.

ERROR 9519 (HY000): expression is of wrong type

• Error code in OceanBase Database: 9519

• Cause: The result data type of the expression is invalid.

• Solution: Check the result data type of the expression.

ERROR 9520 (HY000): cannot compile body of '%.*s' without its specification

• Error code in OceanBase Database: 9520

• Cause: The specification of the user-defined type (UDT) is not declared.

• Solution: Declare the specification.

ERROR 9521 (HY000): subprogram '%.*s' is declared in an object type body and must be defined in the object type specification

• Error code in OceanBase Database: 9521

• Cause: The function definition of the object is not declared in the specification.

• Solution: Declare the function in the specification.

ERROR 9522 (HY000): subprogram or cursor '%.*s' is declared in an object type specification and must be defined in the object type body

• Error code in OceanBase Database: 9522

• Cause: The subprogram or cursor of the object is declared in the specification. It must be defined in the body.

• Solution: Delete or define the declaration.

ERROR 9523 (HY000): An object type may have only 1 MAP or 1 ORDER method

• Error code in OceanBase Database: 9523

• Cause: One MAP function and one ORDER function are defined together. Only one MAP or one ORDER function can be defined for an object type.

• Solution: Retain only one of the MAP and ORDER functions.

ERROR 9524 (HY000): A MAP or ORDER function is required for comparing objects in PL/SQL

• Error code in OceanBase Database: 9524

• Cause: No MAP or ORDER function is defined for comparing object types in PL statements.

• Solution: Define an appropriate MAP or ORDER comparison function.

ERROR 9525 (HY000): Only a function may be a MAP, ORDER or CONSTRUCTOR method

• Error code in OceanBase Database: 9525

• Cause: The MAP, ORDER, or CONSTRUCTOR method is not defined as a function.

• Solution: Modify the definition and rewrite the code.

ERROR 9526 (HY000): identifier '%.*s' too long

• Error code in OceanBase Database: 9526

• Cause: The label name is too long. It can be up to 128 characters in length.

• Solution: Modify the label name.

ERROR 9527 (HY000): a static method cannot be invoked on an instance value

• Error code in OceanBase Database: 9527

• Cause: An instance cannot invoke static functions.

• Solution: Modify the invocation method to invoke functions by type name.

ERROR 9528 (HY000): constructor method name must match type name

• Error code in OceanBase Database: 9528

• Cause: The constructor name is not the same as the type name.

• Solution: Make sure that the constructor name is the same as the type name.

ERROR 9529 (HY000): previous use of '%.*s' conflicts with this use

• Error code in OceanBase Database: 9529

• Cause: A name conflict occurred. For example, variables of different types have duplicate names.

• Solution: Make sure that each variable name is unique.

ERROR 9530 (HY000): the SELF parameter can be declared only as IN or as IN OUT

• Error code in OceanBase Database: 9530

• Cause: The modifier of the SELF parameter must be IN or IN OUT.

• Solution: Modify the modifier as required.

ERROR 9531 (HY000): MAP methods must return a scalar type

• Error code in OceanBase Database: 9531

• Cause: A MAP function must return scalar values but not complex values.

• Solution: Change the type of returned values.

ERROR 9532 (HY000): MAP methods must be declared without any parameters other than (optional) SELF

• Error code in OceanBase Database: 9532

• Cause: A MAP function can contain only the SELF parameter. The SELF parameter can be explicitly or implicitly defined.

• Solution: Remove the excess parameters.

ERROR 9533 (HY000): ORDER methods must return an INTEGER

• Error code in OceanBase Database: 9533

• Cause: An ORDER function must return integers.

• Solution: Change the type of returned values.

ERROR 9534 (HY000): The parameter type in an ORDER method must be the containing object type

• Error code in OceanBase Database: 9534

• Cause: The parameter type of an ORDER function must be the same as the corresponding object type.

• Solution: Change the parameter type.

ERROR 9535 (HY000): Within SQL statements, only equality comparisons of objects are allowed without a map or order function

• Error code in OceanBase Database: 9535

• Cause: Only equality comparison is allowed because the SQL statement contains no MAP or ORDER function.

• Solution: Add a MAP function or an ORDER function, or perform only equality comparison.

ERROR 9537 (HY000): The parameters to an ORDER function must have IN mode

• Error code in OceanBase Database: 9537

• Cause: The parameter modifier of an ORDER function must be IN.

• Solution: Modify the parameter modifier.

ERROR 9538 (HY000): ORDER methods must be declared with 1 (one) parameter in addition to (optional) SELF

• Error code in OceanBase Database: 9538

• Cause: An ORDER function cannot contain only the SELF parameter.

• Solution: Define a parameter of the required type in addition to the SELF parameter.

ERROR 9539 (HY000): type '%.*s' is malformed because it is a non-REF mutually recursive type

• Error code in OceanBase Database: 9539

• Cause: The type encountered a recursive reference.

• Solution: Remove the recursive reference.

ERROR 9540 (HY000): $ERROR: %.*s

• Error code in OceanBase Database: 9540

• Cause: The $ERROR instruction triggered an expected error.

• Solution: Troubleshooting is not required.

ERROR 9541 (HY000): RETURN statement in a CONSTRUCTOR cannot include an expression

• Error code in OceanBase Database: 9541

• Cause: The RETURN statement of the CONSTRUCTOR function cannot contain any expression.

• Solution: Remove the expression from the RETURN statement.

ERROR 9542 (HY000): wrong number or types of arguments in call to '%.*s'

• Error code in OceanBase Database: 9542

• Cause: No matching function was found when the subprocedure was called because the function name, number of parameters, or the parameter type is invalid.

• Solution: Check the specified function name, number of parameters, and parameter type. If the error persists, check the access scope of the function.

ERROR 9543 (HY000): '%.*s' must be a type

• Error code in OceanBase Database: 9543

• Cause: The type modifier used in the declaration or expression is invalid. For example, %type or %rowtype is missing.

• Solution: Modify the type modifier as required.

ERROR 9544 (HY000): too many declarations of '%.*s' match this call

• Error code in OceanBase Database: 9544

• Cause: Multiple function invocation methods are matched. This may be because multiple function invocation methods exist for the function to be invoked and no method can be exactly matched.

• Solution: Make sure that the function name and parameter type are valid.

ERROR 9694 (42000): Duplicate condition information item '%s'

• Error code in OceanBase Database: 9694

• Cause: The definition of condition contains duplicate items.

• Solution: Remove duplicate items from the definition of the condition.

ERROR 9695 (02000): Unhandled user-defined not found condition

• Error code in OceanBase Database: 9695

• Cause: Undefined conditions are used.

• Solution: Use only defined conditions.

ERROR 9743 (HY000): Can't drop or alter a procedure/function from within another stored routine. Can't drop or alter a '%s' from within another stored routine

• Error code in OceanBase Database: 9743
• Error code in MySQL: 1357

ERROR 9747 (HY000): malformed ps packet

• Error code in OceanBase Database: 9747
• Cause: The format of the prepared statement packets sent by the client is invalid.
• Solution: Make sure that the version of the client matches that of the server.

ERROR 9749 (HY000): object does not exist

• Error code in OceanBase Database: 9749
• Cause: The requested object does not exist.
• Solution: Make sure that the specified name of the requested object is correct.

ERROR 9750 (HY000): PL/SQL: index for PL/SQL table out of range for host language array

• Error code in OceanBase Database: 9750
• Cause: When you use a PL/SQL table, the index values exceed the value range of the array.
• Solution: Make sure that the values of the index do not exceed the value range of the array.

ERROR 9754 (HY000): debug_session_id = %u does not exist

• Error code in OceanBase Database: 9754

• Cause: The session ID specified by debug_session_id does not exist.

• Solution: Verify whether the session ID exists.

ERROR 9760 (HY000): cannot fast refresh materialized view %s: %s

• Error code in OceanBase Database: 9760

• Cause: Does not meet the basic requirements for creating an incrementally refreshed materialized view. For example:

  • The base table in the definition of the incrementally refreshed materialized view does not have a materialized view log (mlog) table created.
  • The definition of the incrementally refreshed materialized view does not support including set operators.
  • Columns used in the incrementally refreshed materialized view need to be maintained in the mlog of the base table.

• Solution: Check whether the definition of the incrementally refreshed materialized view meets the basic requirements for incremental refresh. For more information on the basic requirements for incremental refresh, see Refresh materialized views.

ERROR 9762 (42000): Loading local data is disabled; this must be enabled on both the client and server sides

• Error code in OceanBase Database: 9762

• Error code in MySQL: 3948

• Cause: Local data import failed.

• Solution: To use the local data import feature, make sure that:

  • The version of OceanBase Client (OBClient) is V2.2.4 or later.

  • The version of OceanBase Database Proxy (ODP) is V3.2.4 or later. If you directly connect to an OBServer node, ignore this requirement.

  • The version of OceanBase Connector/J is V2.4.8 or later, if Java and OceanBase Connector/J are used.

    You can directly use a MySQL client or a native MariaDB client of any version.

    Note

    When you use a MySQL or MariaDB client to connect to your database, the command-line option --local-infile is required.

    If the version requirements are met, you need to enable the local_infile variable.

    • Enable the variable.

      set @@local_infile=1;
      

    • Check the variable.

      show variables like 'local_infile';
      

ERROR 9765 (HY000): object '%.*s' must be of type function or array to be used this way

• Error code in OceanBase Database: 9765

• Cause: The object '%.*s' must be a function or an array.

• Solution: Check the object type and adjust it as needed.

ERROR 20000 (HY000): The stored procedure 'raise_application_error' was called which causes this error to be generated","-%05ld: %.*s

• Error code in OceanBase Database: 20000

• Cause: The RAISE_APPLICATION_ERROR procedure was called. This error code is implicit and is specified by a user. Error codes that identify the RAISE_APPLICATION_ERROR procedure range from 20000 to 20999.

• Solution: This user-defined error is explicitly thrown by a user, and troubleshooting is not required.

ERROR 21000 (HY000): error number argument to raise_application_error of '%d' is out of range

• Error code in OceanBase Database: 21000

• Cause: The user-defined error code for the RAISE_APPLICATION_ERROR procedure is invalid. The error code must range from 20000 to 20999.

• Solution: Specify an error code within the range of 20000 to 20999.

ERROR 32491 (HY000): snapshot expression not allowed here

• Error code in OceanBase Database: 32491

• Cause: The SNAPSHOT expression is not allowed in the current statement. The expression can be used only in a read-only statement.

• Solution: Remove the SNAPSHOT expression or set the statement to be a read-only statement.