solidDB Help : solidDB reference : Error codes : solidDB procedure errors
  
solidDB procedure errors
The solidDB procedure error codes are described in the following table:
 
Code
Class
Type
Description
23001
Procedure
Error
Undefined symbol symbol.
23002
Procedure
Error
Undefined cursor cursor.
You have used a cursor that has not been defined in a procedure definition.
23003
Procedure
Error
Illegal SQL operation operation.
23004
Procedure
Error
Syntax error: parse error, line line number. Check the syntax of your procedure.
23005
Procedure
Error
Procedure procedure not found.
23006
Procedure
Error
Wrong number of parameters for procedure procedure.
23007
Procedure
Error
Procedure name value conflicts with an existing entity.
Choose a unique name for a procedure. The specified name is already used.
23010
Procedure
Error
Incompatible event event parameter type, line line number.
23011
Procedure
Error
Wrong number of parameter for event event, line line number.
23012
Procedure
Error
Duplicate wait for event event, line line number.
23013
Procedure
Error
Undefined sequence sequence.
23014
Procedure
Error
Duplicate sequence name sequence.
23015
Procedure
Error
Sequence sequence not found.
23016
Procedure
Error
Incompatible variable type in call to sequence sequence, line line number.
23017
Procedure
Error
Duplicate symbol symbol.
You have duplicate definitions for a symbol.
23018
Procedure
Error
Procedure owner owner not found.
23019
Procedure
Error
Duplicate cursor name 'cursor'
23020
Procedure
Error
Illegal option option for WHENEVER SQLERROR ... statement.
23021
Procedure
Error
RETURN ROW not allowed in procedure with no return type, line line number.
23022
Procedure
Error
SQL String variable variable must be of character data type, line line number.
23023
Procedure
Error
Call syntax error: syntax, line line number.
23024
Procedure
Error
Trigger trigger_name not found. Trigger name not found.
23025
Procedure
Error
Trigger name trigger_name conflicts with an existing entity.
Trigger name conflicts with some other database object. Triggers share the same name space, as for example, in table and procedures.
23026
Procedure
Error
Variable variable is of character type, line line number.
A CHAR or WCHAR variable is required for the operations like RETURN SQLERROR variable.
23027
Procedure
Error
Duplicate reference to column column_name in trigger definition. A column can be referenced only one time in the trigger definition.
23028
Procedure
Error
Commit and rollback are not allowed in triggers.
Trigger body must not contain commit or rollback statements.
23029
Procedure
Error
Commit and rollback are not allowed in functions.
23030
Procedure
Error
Function function_name not found
23501
Procedure
Error
Cursor cursor is not open.
23502
Procedure
Error
Illegal number of columns in EXECUTE ... procedure in cursor cursor.
You will see this message if the number of columns that you selected does not match the number of variables in the INTO clause.
23503
Procedure
Error
Previous SQL operation operation failed in cursor cursor.
23504
Procedure
Error
Cursor cursor is not executed.
23505
Procedure
Error
Cursor cursor is not a SELECT statement.
23506
Procedure
Error
End of table in cursor cursor.
23508
Procedure
Error
Illegal assignment, line line number.
23509
Procedure
Error
In procedure line line number Stmt statement was not in error state in RETURN SQLERROR OF ...
23510
Procedure
Error
In procedure line line number Transaction cannot be set read only, because it has written already.
23511
Procedure
Error
In procedure line line number USING part is missing for dynamic parameters for procedure.
23512
Procedure
Error
In procedure line line number USING list is too short for procedure.
23513
Procedure
Error
In procedure line line number Comparison between incompatible types data type and data type.
23514
Procedure
Error
In procedure line line number type data type is illegal for logical expression.
23515
Procedure
Error
In procedure line line number assignment of parameter parameter in list list failed.
One possible cause of this error is trying to bind a parameter in a prepared statement that has a clause like "...? IS NULL...". To work around this problem, we recommend that you cast the placeholder (the question mark) to the appropriate data type. For example, if you are binding a parameter of type TIMESTAMP, then replace
WHEN ? IS NULL
with
WHEN CAST(? AS TIMESTAMP) IS NULL
23516
Procedure
Error
In CALL procedure, assignment of parameter parameter failed.
23517
Procedure
Error
Internal error: illegal operation code in procedure. Contact technical support for more information.
23518
Procedure
Error
User error: error_text.
User generated error in a procedure or trigger. User can generate this error by using a statement RETURN SQLERROR string or RETURN SQLERROR variable. Variable must be of CHAR or WCHAR type.
23519
Procedure
Error
Fetch previous is not supported for procedures.
Fetch previous row does not work for result sets returned by a procedure.
23520
Procedure
Error
Invalid link name given in remote procedure call.
23521
Procedure
Error
Link name not given in remote procedure call.
23522
Procedure
Error
Dynamic parameters not allowed with remote procedure call.
23523
Procedure
Error
Default node not defined.
23524
Procedure
Error
Could not load application.
23525
Procedure
Error
Function not found from the DLL.
23526
Procedure
Error
In CALL procedure_name assignment of default value of parameter parameter_number failed.
This error message occurs if you call a procedure with too few parameters and you have not specified default values for the missing parameters.
23527
Procedure
Error
In CALL procedure_name parameter parameter_number assigned twice. This occurs if you specify the same parameter more than one time.
23528
Procedure
Error
Application is already running.
23529
Procedure
Error
Application is not running.
23530
Procedure
Error
Event wait is not allowed inside a scalar function call.
23531
Procedure
Error
Event wait is not allowed inside a trigger action.
23532
Procedure
Error
SQL DML statements are not allowed inside a scalar function call.
23533
Procedure
Error
SQL DDL statements are not allowed inside a scalar function call.
23534
Procedure
Error
External procedure/function library name load failed.
23535
Procedure
Error
External procedure/function name name was not found from library library_name.
23538
Procedure
Error
Procedure procedure_name output parameter number number assign failed.
23539
Procedure
Error
Procedure/function name return column number number assign failed.
23540
Procedure
Error
External procedure/function name reported error, sqlstate: sqlstate message: message.
23541
Procedure
Error
External procedure/function cannot be executed without an active user connection.
Go up to
Error codes