This range indicates procedural language (PL) error codes.
ERROR 9502 (HY000) : OUT and IN/OUT modes cannot be used in this context
OceanBase error code: 9502
Cause: The
OUTparameter is allowed only when the DML statement of the dynamic statement contains areturningvariable and there is no externalINTOvariable.Solution: Check whether the usage of
OUTparameters in the dynamic statement complies with the specifications.
ERROR 9503 (HY000) : object '%.*s' of type %.*s not found in schema '%.*s'
OceanBase error code: 9503
Cause: An object of the specified type and name does not exist.
Solution: Use the correct type and object name.
ERROR 9506 (HY000) : Only schema-level programs allow %s
OceanBase error code: 9506
Cause: The
INVOKER RIGHTclause is only allowed to be defined in a standalone procedure or function.Solution: Remove the
INVOKER RIGHTclause.
ERROR 9507 (HY000) : at most one declaration for '%.*s' is permitted
OceanBase error code: 9507
Cause: A duplicate identifier was found in the same namespace.
Solution: Ensure the uniqueness of identifiers in the same namespace.
ERROR 9508 (HY000) : duplicate fields in RECORD,TABLE or argument list are not permitted
OceanBase error code: 9508
Cause: The PL has parameters with the same name.
Solution: Parameter names in PL must be unique.
ERROR 9509 (HY000) : Pragma AUTONOMOUS_TRANSACTION cannot be specified here
OceanBase error code: 9509
Cause: The autonomous transaction clause is placed in an incorrect location. It can only appear in the first-level block.
Solution: Modify the position of the autonomous transaction clause.
ERROR 9510 (HY000) : illegal EXIT/CONTINUE statement; it must appear inside a loop
OceanBase error code: 9510
Cause: The
EXITorCONTINUEstatement must be used within a loop body.Solution: Check whether the
EXITorCONTINUEclause is used correctly.
ERROR 9512 (HY000) : EXIT/CONTINUE label '%.*s' must label a LOOP statement
OceanBase error code: 9512
Cause: The destination of the
EXITorCONTINUEclause is not a valid label.Solution: Check whether the destination label of the
EXITorCONTINUEclause is valid.
ERROR 9513 (HY000) : expression '%.*s' is inappropriate as the left hand side of an assignment statement
OceanBase error code: 9513
Cause: A static cursor cannot be used for assignment.
Solution: Check the validity of the assignment statement.
ERROR 9514 (HY000) : a variable declared NOT NULL must have an initialization assignment
OceanBase error code: 9514
Cause: A variable with a
NOT NULLconstraint is not explicitly initialized.Solution: Remove the
NOT NULLconstraint or explicitly initialize the variable.
ERROR 9515 (HY000) : Constant declarations should contain initialization assignments
OceanBase error code: 9515
Cause: A constant variable is not explicitly initialized.
Solution: Remove the constant or explicitly initialize the variable.
ERROR 9516 (HY000) : Cursor Variables cannot be declared as part of a package
OceanBase error code: 9516
Cause: Cursors are not allowed to be declared within a package.
ERROR 9518 (HY000) : value in LIMIT clause: \'%.*s\' use is invalid
OceanBase error code: 9518
Cause: The data type of the expression in the
LIMITclause is incorrect.Solution: Change the data type to a numeric type.
ERROR 9519 (HY000) : expression is of wrong type
OceanBase error code: 9519
Cause: The result type of the expression does not meet expectations.
Solution: Check the result type of the expression.
ERROR 9520 (HY000) : cannot compile body of '%.*s' without its specification
OceanBase error code: 9520
Cause: The UDT lacks a SPEC declaration.
Solution: Add a SPEC declaration first.
ERROR 9521 (HY000) : subprogram '%.*s' is declared in an object type body and must be defined in the object type specification
OceanBase error code: 9521
Cause: Functions within an object must be declared in the SPEC first.
Solution: Declare the functions in the SPEC.
ERROR 9522 (HY000) : subprogram or cursor '%.*s' is declared in an object type specification and must be defined in the object type body
OceanBase error code: 9522
Cause: Subprograms or cursors declared in the SPEC of an object type must be defined in the BODY.
Solution: Remove the declaration or define it.
ERROR 9523 (HY000) : An object type may have only 1 MAP or 1 ORDER method
OceanBase error code: 9523
Cause: An object type can define either one
MAPor oneORDERfunction, but not both.Solution: Remove the redundant
MAPorORDERfunction and retain the appropriate one.
ERROR 9524 (HY000) : A MAP or ORDER function is required for comparing objects in PL/SQL
OceanBase error code: 9524
Cause: To compare object types in PL, you need to define a
MAPorORDERfunction.Solution: Define an appropriate
MAPorORDERcomparison function.
ERROR 9525 (HY000) : Only a function may be a MAP, ORDER or CONSTRUCTOR method
OceanBase error code: 9525
Cause:
MAP,ORDER, orCONSTRUCTORmust be defined as a FUNCTION.Solution: Modify the definition and recompile.
ERROR 9526 (HY000) : identifier '%.*s' too long
OceanBase error code: 9526
Cause: The label name is too long. The maximum length is 128 characters.
Solution: Modify the length.
ERROR 9527 (HY000) : a static method cannot be invoked on an instance value
OceanBase error code: 9527
Cause: Instances cannot call static functions.
Solution: Modify the calling method to use the type name.
ERROR 9528 (HY000) : constructor method name must match type name
OceanBase error code: 9528
Cause: The constructor name must match the type name.
Solution: Ensure they are the same.
ERROR 9529 (HY000) : previous use of '%.*s' conflicts with this use
OceanBase error code: 9529
Cause: Naming conflict. For example, defining variables of different types, but the variable name is already used elsewhere.
Solution: Ensure the named variable does not duplicate another name.
ERROR 9530 (HY000) : the SELF parameter can be declared only as IN or as IN OUT
OceanBase error code: 9530
Cause: The modifier for the
SELFparameter must beINorIN OUT, not other modifiers.Solution: Modify the modifier to meet the requirement.
ERROR 9531 (HY000) : MAP methods must return a scalar type
OceanBase error code: 9531
Cause: A
MAPfunction must return a scalar value, not a complex type.Solution: Modify the function's return type.
ERROR 9532 (HY000) : MAP methods must be declared without any parameters other than (optional) SELF
OceanBase error code: 9532
Cause: A
MAPfunction has exactly one parameter, which isSELF(either explicitly or implicitly defined).Solution: Remove any extra parameters.
ERROR 9533 (HY000) : ORDER methods must return an INTEGER
OceanBase error code: 9533
Cause: An
ORDERfunction must return an integer.Solution: Modify the function's return type.
ERROR 9534 (HY000) : The parameter type in an ORDER method must be the containing object type
OceanBase error code: 9534
Cause: The parameter type of an
ORDERfunction must be the type of its containing object.Solution: Modify the parameter type.
ERROR 9535 (HY000) : Within SQL statements, only equality comparisons of objects are allowed without a map or order function
OceanBase error code: 9535
Cause: In SQL statements, equality comparisons are the only operations that are supported without a
MAPorORDERfunction.Solution: Add a
MAPorORDERfunction, or perform only equality comparisons.
ERROR 9537 (HY000) : The parameters to an ORDER function must have IN mode
OceanBase error code: 9537
Cause: The parameter modifier for an
ORDERfunction must beIN.Solution: Modify the parameter modifier.
ERROR 9538 (HY000) : ORDER methods must be declared with 1 (one) parameter in addition to (optional) SELF
OceanBase error code: 9538
Cause: An
ORDERfunction must define a parameter other thanSELF.Solution: Define an additional parameter of the corresponding type.
ERROR 9539 (HY000) : type '%.*s' is malformed because it is a non-REF mutually recursive type
OceanBase error code: 9539
Cause: The types are mutually recursively referenced.
Solution: Resolve the mutual recursion.
ERROR 9540 (HY000) : $ERROR: %.*s
OceanBase error code: 9540
Cause: An exception generated by the
$ERRORdirective. This is an expected exception.Solution: No action is required.
ERROR 9541 (HY000) : RETURN statement in a CONSTRUCTOR cannot include an expression
OceanBase error code: 9541
Cause: A
RETURNstatement in aCONSTRUCTORfunction cannot contain any expression.Solution: Remove the expression following
RETURN.
ERROR 9542 (HY000) : wrong number or types of arguments in call to '%.*s'
OceanBase error code: 9542
Cause: No suitable function was found when calling the subprocedure. This may be due to an incorrect function name, an incorrect number of parameters, or mismatched parameter types.
Solution: Check the function name, the number of parameters, and the parameter types. If the issue persists, check the function's access scope.
ERROR 9543 (HY000) : '%.*s' must be a type
OceanBase error code: 9543
Cause: The type modifier in a declaration or expression is not a valid type. For example,
%typeor%rowtypemight be missing.Solution: Modify the modifier to a valid type.
ERROR 9544 (HY000) : too many declarations of '%.*s' match this call
OceanBase error code: 9544
Cause: Multiple function calls match. There may be multiple matching ways to call the function, and none can be matched exactly.
Solution: Check whether the function name called is correct and whether the parameter types are correct.
ERROR 9574 (HY000) : document is not a stylesheet
OceanBase error code: 9574
Cause: Attempted to use a non-stylesheet document as an XSL style sheet.
Solution: Check the format and validity of the XSL style sheet to ensure there are no format errors, parameter errors, etc.
ERROR 9694 (42000) : Duplicate condition information item '%s'
OceanBase error code: 9694
Cause: Duplicate items appear in the condition definition.
Solution: Remove duplicate items from the condition definition.
ERROR 9695 (02000) : Unhandled user-defined not found condition
OceanBase error code: 9695
Cause: A user-defined condition was used.
Solution: Do not use undefined 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
- OceanBase error code: 9743
- Compatible MySQL error code: 1357
ERROR 9747 (HY000) : malformed ps packet
- OceanBase error code: 9747
- Cause: The prepared statement packet sent by the client is malformed.
- Solution: Check whether the client and server versions are compatible and ensure that they match.
ERROR 9749 (HY000) : object does not exist
- OceanBase error code: 9749
- Cause: The requested object does not exist.
- Solution: Check whether the name of the requested object is correct or incorrect, and confirm whether the object can be found.
ERROR 9750 (HY000) : PL/SQL: index for PL/SQL table out of range for host language array
- OceanBase error code: 9750
- Cause: When using a PL/SQL table, the index exceeds the range of the array.
- Solution: Ensure that the index value does not exceed the array range.
ERROR 9754 (HY000) : debug_session_id = %u does not exist
OceanBase error code: 9754
Cause:
debug_session_iddoes not exist.Solution: Check whether the session ID exists.
ERROR 9760 (HY000) : cannot fast refresh materialized view %s: %s
OceanBase error code: 9760
Cause: Does not meet the basic requirements for creating an incremental refresh materialized view. For example:
- The base table in the definition of the incremental refresh materialized view has not created a materialized view log (mlog) table.
- The definition of the incremental refresh materialized view does not support set operators.
- The columns used in the incremental refresh materialized view need to be maintained in the base table's mlog.
Solution: Check whether the definition for creating the incremental refresh materialized view meets the basic requirements for incremental refresh. For information about the basic requirements for incremental refresh, see Refresh a materialized view.
ERROR 9762 (42000) : Loading local data is disabled; this must be enabled on both the client and server sides
OceanBase error code: 9762
Compatible MySQL error code: 3948
Cause: Local Data import failed.
Solution: To use the LOAD DATA LOCAL feature, ensure that:
OBClient version is not earlier than 2.2.4.
ODP version is not earlier than 3.2.4 (this requirement does not apply for direct connection to OBServer).
The OBDJDBC version is 2.4.8 or later (if using Java + OBDJDBC).
Alternatively, you can directly use the native MySQL or MariaDB client, with no specific version requirements.
Note
When connecting to a database using the MySQL/MariaDB client, add the command-line parameter
--local-infile.If the version is correct, you need to set the
local_infilevariable to ON: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
OceanBase error code: 9765
Cause: The object '%.*s' must be of type function or array to be used this way.
Solution: Check the object's type and adjust it as needed.
ERROR 9800 (HY000) : To be compatible with MySQL, if an exception occurs when compiling an OB PL object (such as the object does not exist or a parameter mismatch), the relevant statement will be converted to a statement that throws an exception, and compiled object will be evicted by any schema change which may cause performance problems. User should create or redefine the pl object of the problem indicated in the warning. Problem object name: '%.*s'
OceanBase error code: 9800
Cause:
A MySQL compatibility exception occurred during PL object compilation. Possible scenarios include:
- The referenced object does not exist.
- Parameter mismatch.
- Type incompatibility.
Solution: Fix the references, parameters, types, and other issues in the PL object, then recompile it to prevent performance problems caused by frequent recompilations.
ERROR 9808 (HY000) : Table type is not valid, the definition of materialized view can only reference user tables or other materialized views
OceanBase error code: 9808
Cause: The table type referenced in the materialized view definition is invalid.
Solution: Check the object types referenced in the materialized view definition (a materialized view definition can only reference user tables or other materialized views).
ERROR 9809 (HY000) : Base tables are altered during the creation or complete refresh of materialized views, please try again when base tables have no ongoing DDL operations
OceanBase error code: 9809
Cause: A DDL operation is in progress on the base table during the creation or complete refresh of the materialized view.
Solution: Check whether any DDL operations are in progress on the base table of the materialized view.
ERROR 9810 (HY000) : Materialized view %s.%s has invalid dependency info, please perform a complete refresh to recover
OceanBase error code: 9810
Cause: The dependency information for the materialized view
%sis invalid.Solution: Perform a complete refresh on the materialized view.
ERROR 9826 (HY000) : Python env could not be found
OceanBase error code: 9826
Cause: The Python environment could not be found.
Solution: Confirm and configure the Python environment.
ERROR 9827 (HY000) : python params error", "%s
OceanBase error code: 9827
Cause: An invalid Python parameter was specified.
Solution: Check and configure the correct Python parameters.
ERROR 9828 (HY000) : python execute error", "%s
OceanBase error code: 9828
Cause: An error occurred while executing Python code or scripts in the database environment.
Solution: Check the Python code or scripts and verify that the environment is compatible.
ERROR 9832 (HY000) : cannot alter a type that is not valid
OceanBase error code: 9832
Cause: An invalid user-defined type cannot be modified.
Solution: The core approach is similar to resolving object incompatibilities during database migration, which is to modify the object's definition to make it valid in the target environment.
ERROR 9834 (HY000) : must specify either CASCADE or INVALIDATE option
OceanBase error code: 9834
Cause: Either the
CASCADEorINVALIDATEoption must be specified.Solution: At the end of your
ALTERstatement, add theCASCADEorINVALIDATEoption based on your business requirements.
ERROR 20000 (HY000) : The stored procedure 'raise_application_error' was called which causes this error to be generated","-%05ld: %.*s
OceanBase error code: 20000
Cause: A user-defined exception was generated by calling the
RAISE_APPLICATION_ERRORprocedure. This error code is implicit; the actual error code is determined by the user. The user error codes specified by theRAISE_APPLICATION_ERRORprocedure range from 20000 to 20999.Solution: User-defined exceptions are explicitly thrown by the user and do not require handling.
ERROR 21000 (HY000) : error number argument to raise_application_error of '%d' is out of range
OceanBase error code: 21000
Cause: The user-defined exception error code range generated by
RAISE_APPLICATION_ERRORis incorrect. The user-specified error code range must be between 20000 and 20999.Solution: Adjust the error code range to between 20000 and 20999.
ERROR 32491 (HY000) : snapshot expression not allowed here
OceanBase error code: 32491
Cause: SNAPSHOT expressions are not allowed here. SNAPSHOT expressions are only supported in read-only statements.
Solution: Remove the SNAPSHOT expression or modify the statement to be read-only.