PL/MX messages (17000 through 17540)

SQL 17000

17000 SVM type exception while executing a UDR. Program counter = pc, additional info = value.

: Where,
type: describes the exception.
pc: is the program counter value at the point of the exception.
value: is an integer whose meaning depends on the exception as shown in the following table.

Exception	Meaning	Additional info
Arithmetic Overflow	The result of an operation exceeded the allowable range.	The opcode that was executing when the exception occurred.
Invalid Opcode*	An invalid instruction was encountered.	The invalid opcode.
Divide By Zero	An attempt was made to divide with a zero divisor.	The opcode that was executing when the exception occurred.
Program Counter Bounds	The program counter pointed to an invalid code address.	The opcode that was executing when the exception occurred.
Byte Address Bounds	The referenced byte address was invalid.	The opcode that was executing when the exception occurred.
Word Address Bounds	The referenced word address was invalid.	The opcode that was executing when the exception occurred.
Stack Overflow	The stack grew beyond the stack limit.	The opcode that was executing when the exception occurred.
Stack Underflow	An attempt was made to reference a stack element below the bottom of the stack.	The opcode that was executing when the exception occurred.
Missing Return	The end of a function was reached without executing a RETURN statement.	Unused
Null Assignment	An attempt was made to assign NULL to a NOT NULL variable.	The opcode that was executing when the exception occurred.
Null Operand	An operation required an operand that was non-NULL.	The opcode that was executing when the exception occurred.
Invalid Operand	The operand supplied for an operation was invalid.	The opcode that was executing when the exception occurred.
Instruction Limit	The limit for instructions executed was reached.	The opcode that was executing when the exception occurred.
Unknown*	An unrecognized exception occurred. This is an internal error.	The exception number that was unrecognized.

Cause

The SVM encounters an exception while executing a UDR as part of a query.

Effect

The operation fails.

Recovery

Examine source code, correct any errors found, recreate the function, and retry the query.

SQL 17001

17001 Internal error. Unexpected UDR result type (number) requested.

: Where,
number: is the numeric type that is requested.

Cause

The UDR requests an invalid result type from the SVM.

Effect

The operation fails.

Recovery

This is an internal error. Contact your service provider.

SQL 17002

17002 SVM unable to allocate memory.

Cause

The SVM is unable to allocate the required memory. It is typically a transient condition.

Effect

The operation fails.

Recovery

This is typically a transient condition. If the error persists, examine and adjust the system load and tuning.

SQL 17003

17003 Internal error. Invalid arguments passed to SVM initialize (code size = n1, memory size = n2).

: Where,
n1: is the code size value.
n2: is the memory size requested.

Cause

The SVM is unable to initialize due to parameter errors.

Effect

The operation fails.

Recovery

This is an internal error. Contact your service provider.

SQL 17100

17100 Unable to load filename. Memory allocation failure.

: Where,
filename: is the name of the file being loaded.

Cause

The memory had to load a UDR object file that is unavailable. This is typically a transient condition.

Effect

The operation fails.

Recovery

If the error persists, examine and adjust the system load and tuning.

SQL 17101

17101 Unable to load filename. Internal error (NULL object file instance).

: Where,
filename: is the name of the file being loaded.

Cause

This is an internal error.

Effect

The operation fails.

Recovery

This is an internal error. Contact your service provider.

SQL 17102

17102 Unable to load filename. Unexpected error number occurred.

: Where,
filename: is the name of the file being loaded.
number: is the number of the error encountered.

Cause

This is an internal error.

Effect

The operation fails.

Recovery

This is an internal error. Contact your service provider.

SQL 17103

17103 Unable to load filename. SQL error number accessing object file.

: Where,
filename: is the name of the file being loaded.
number: is the number of the error encountered.

Cause

SQL error is encountered while loading a UDR object file. Generally, this is an unexpected error.

Effect

The operation fails.

Recovery

Resolve the SQL error.

SQL 17200

17200 Internal error on SVM object file. Attempted operation on unopened file.

Cause

You attempted the operation on an unopened file.

Effect

The operation fails.

Recovery

This is an internal error. If the error persists, contact your service provider.

SQL 17201

17201 Internal error on SVM object file. Incomplete derived class.

Cause

This is an internal error.

Effect

The operation fails.

Recovery

This is an internal error. If the error persists, contact your service provider.

SQL 17202

17202 Internal error on SVM object file. Invalid program number specified.

Cause

You specified a program number that is invalid.

Effect

The operation fails.

Recovery

This is an internal error. If the error persists, contact your service provider.

SQL 17203

17203 Internal error on SVM object file. Unrecognized section name specified.

Cause

You specified a section name that the system does not recognize.

Effect

The operation fails.

Recovery

This is an internal error. If the error persists, contact your service provider.

SQL 17204

17204 Internal error on SVM object file. Invalid section number specified.

Cause

You specified a section name that is invalid.

Effect

The operation fails.

Recovery

This is an internal error. If the error persists, contact your service provider.

SQL 17205

17105 Unable to allocate memory for SVM object file operation.

Cause

The memory required to load a UDR object file is unavailable.

Effect

The operation fails.

Recovery

This is typically a transient condition. If the error persists, examine and adjust the system load and tuning.

SQL 17206

17206 Internal error on SVM object file. Unsupported access mode.

Cause

The access mode you have used is not supported.

Effect

The operation fails.

Recovery

This is an internal error. If the error persists, contact your service provider.

SQL 17207

17207 Internal error on SVM object file. Invalid parameter number specified.

Cause

You specified an invalid parameter number.

Effect

The operation fails.

Recovery

This is an internal error. If the error persists, contact your service provider.

SQL 17500

17500 Unexpected end of file.

Cause

The end of the input source is encountered before one of the following:

A closing quote for a quoted identifier.
The end of a line.
The end of a multiline comment.
The end of a string.

Effect

The operation fails.

Recovery

Terminate the source properly and retry the compilation.

SQL 17502

17502 Multiline comment nested within a multiline comment.

Cause

A multiline comment is nested within a multiline comment.

Effect

The operation fails.

Recovery

Correct the source and retry the compilation.

SQL 17503

17503 Illegal character char found in quoted identifier.

: Where,
char: is the illegal character in the source.

Cause

A character is found as part of a quoted identifier that is not legal for use in the quoted identifier.

Effect

The operation fails.

Recovery

Remove the character from the source and retry the compilation.

SQL 17504

17504 Illegal character char.

: Where,
char: is the illegal character in the source.

Cause

An illegal character is found in the source.

Effect

The operation fails.

Recovery

Remove the illegal character from the source and retry the compilation.

SQL 17505

17505 Empty identifier string not allowed.

Cause

You have not provided any characters in a quoted identifier.

Effect

The operation fails.

Recovery

Create a valid quoted identifier by adding one or more legal characters and retry the compilation.

SQL 17506

17506 Quoted Identifier greater than 30 characters in length... truncating.

Cause

A quoted identifier is encountered that is longer than 30 characters. The identifier has been truncated.

Effect

None. This is a warning message.

Recovery

None.

SQL 17507

17507 Identifier greater than 30 characters in length... truncating.

Cause

An identifier is encountered that is longer than 30 characters. The identifier has been truncated.

Effect

None. This is a warning message.

Recovery

None.

SQL 17508

17508 op operator missing description.

: Where,
op: is the operator being scanned.
description: indicates what is missing.

Cause

You specified a double character symbol incorrectly.

Effect

The operation fails.

Recovery

Correct the symbol and retry the compilation.

SQL 17509

17509 Unrecognized command line argument option.

: Where,
option: is the command-line argument being scanned.

Cause

An unrecognized option is encountered in the command line.

Effect

The operation fails.

Recovery

Correct the command line and retry the compilation.

SQL 17510

17510 Setting for argument option incorrect.

: Where,
option: is the command-line argument being scanned.

Cause

You provided an incorrect argument for a command-line option.

Effect

The operation fails.

Recovery

Correct the argument and retry the compilation.

SQL 17511

17511 Command line option opt is incomplete.

: Where,
opt: is the command-line argument being scanned.

Cause

You provided an incorrect argument for a command-line option.

Effect

The operation fails.

Recovery

Correct the argument and retry the compilation.

SQL 17512

17512 Unable to open source file filename.

Cause

The compiler is unable to open the specified source file.

Effect

The operation fails.

Recovery

Correct the command line or ensure that the specified file is present. Retry the compilation.

SQL 17513

17513 Syntax error additional-information.

: Where,
additional-information: provides more information about the syntax error.

Cause

The compiler encounters invalid PL/MX syntax.

Effect

The operation fails.

Recovery

Correct the errors in the syntax and retry the compilation.

SQL 17514

17514 IO Error.

Cause

The compiler has an unexpected IO error.

Effect

The operation fails.

Recovery

Retry the compilation.

SQL 17515

17515 symbol has already been declared in the current scope.

: Where,
symbol: is the identifier in error.

Cause

The compiler encounters another declaration for an identifier, that has already been declared in the current scope.

Effect

The operation fails.

Recovery

Remove or rename the identifier and retry the compilation.

SQL 17516

17516 symbol is not declared in the current scope.

: Where,
symbol: is the identifier in error.

Cause

The compiler encounters an identifier this is referenced but is not declared.

Effect

The operation fails.

Recovery

Declare the identifier and retry the compilation.

SQL 17517

17517 Cannot assign to constant: symbol.

: Where,
symbol: is the identifier in error.

Cause

The compiler encounters an attempt to assign a value to an identifier that is declared as a constant outside of initialization.

Effect

The operation fails.

Recovery

Make the identifier a variable or change the source to avoid assigning a value to it. Retry the compilation.

SQL 17518

17518 Cannot assign to IN parameter: symbol.

: Where,
symbol: is the parameter in error.

Cause

The compiler encounters an attempt to assign a value to a parameter that is specified with the IN parameter mode.

Effect

The operation fails.

Recovery

Change the parameter mode for the parameter to IN OUT or change the source to avoid assigning a value to it. Retry the compilation.

SQL 17519

17519 A return statement in a function must contain an expression.

Cause

A return statement is missing the required expression.

Effect

The operation fails.

Recovery

Add an expression to the statement and retry the compilation.

SQL 17521

17521 string is not a supported type.

Cause

An unsupported datatype is specified.

Effect

The operation fails.

Recovery

Change the datatype to a supported datatype and retry the compilation.

SQL 17522

17522 Boolean expression, not integer expression, is required after keyword.

: Where,
keyword: provides more context for the error.

Cause

An arithmetic expression is used where a Boolean expression is required.

Effect

The operation fails.

Recovery

Correct the expression and retry the compilation.

SQL 17523

17523 Cannot convert between integers and booleans context.

: Where,
context: provides more context for the error.

Cause

You attempted to combine Booleans and integers such that it requires conversion.

Effect

The operation fails.

Recovery

Change the expression such that only compatible conversions occur and retry the compilation.

SQL 17524

17524 For the comparison operator, can't have one integer and one boolean operand.

: Where,
comparison: is the comparison operator in the expression.

Cause

You attempted to combine Booleans and integers in an incompatible way with a comparison operator.

Effect

The operation fails.

Recovery

Change the expression such that only compatible comparisons occur and retry the compilation.

SQL 17525

17525 For the unary-op operator, the operand must be integer, not boolean.

: Where,
unary-op: is the operator in the expression.

Cause

You attempted to use an arithmetic unary operator with a Boolean operand.

Effect

The operation fails.

Recovery

Change the expression such that an arithmetic operand is used and retry the compilation.

SQL 17526

17526 For the binary-op operator, the operands must be integer, not boolean.

: Where,
binary-op: is the operator in the expression.

Cause

You attempted to use an arithmetic binary operator with Boolean operands.

Effect

The operation fails.

Recovery

Change the expression such that arithmetic operands are used and retry the compilation.

SQL 17527

17527 No source file name was specified.

Cause

The standalone compiler is executed without a filename argument.

Effect

The operation fails.

Recovery

Add a filename and retry the command.

SQL 17528

17528 More than one source file name was specified.

Cause

The standalone compiler is executed with more than one filename argument.

Effect

The operation fails.

Recovery

Change the command to specify only one filename and retry the command.

SQL 17529

17529 Unrecognized package name specified.

Cause

An unrecognized package name is specified.

Effect

The operation fails.

Recovery

Change the call to specify a recognized package and retry the compilation.

SQL 17530

17530 DBMS_OUTPUT.procedure not found.

: Where,
procedure: is the name of the missing procedure.

Cause

An unrecognized or unsupported procedure of the DBMS_OUTPUT package is used.

Effect

The operation fails.

Recovery

Change the call to use a recognized procedure and retry the compilation.

SQL 17531

17531 DBMS_OUTPUT only supports integer expressions and string literals.

Cause

An unrecognized or unsupported procedure of the DBMS_OUTPUT package is used.

Effect

The operation fails.

Recovery

Change the call to use a recognized procedure and retry the compilation.

SQL 17532

17532 string is not allowed as a parameter type or return type.

: Where,
string: is the datatype in error.

Cause

You attempted to use an unsupported datatype as a parameter or return value.

Effect

The operation fails.

Recovery

Change the call to use a recognized procedure and retry the compilation.

SQL 17533

17533 For the NOT operator, the operand must be boolean, not integer.

Cause

You attempted to use integer operand with the NOT operator.

Effect

The operation fails.

Recovery

Change the operand to a Boolean datatype and retry the compilation.

SQL 17534

17534 For the boolean-op operator, the operands must be boolean, not integer.

: Where,
boolean-op: is the operator in the expression.

Cause

You attempted to use integer operands with a Boolean operator.

Effect

The operation fails.

Recovery

Change the operands to the Boolean datatype and retry the compilation.

SQL 17535

17535 Cannot use SQL/MX reserved word string as an identifier.

: Where,
string: is the identifier being scanned.

Cause

You attempted to use a NonStop SQL/MX reserved word as an identifier.

Effect

The operation fails.

Recovery

Change the identifier name to a nonreserved word or to a quoted identifier and retry the compilation.

SQL 17536

17536 Syntax error, unexpected token1, expecting token2.

: Where,
token1: is the item being scanned.
token2: is a suggestion of an item that is more acceptable.

Cause

An invalid PL/MX syntax is encountered during compilation.

Effect

The operation fails.

Recovery

Change the source to correct syntax and retry the compilation.

SQL 17537

17537 Not a supported type of numeric literal.

Cause

A numeric literal, such as a decimal literal, that is not yet supported is encountered.

Effect

The operation fails.

Recovery

Change the source to use a supported numeric literal and retry the compilation.

SQL 17538

17538 Name at the end of the subprogram does not match the name at the top.

Cause

The name used in the final end of a function body does not match the name of the function.

Effect

The operation fails.

Recovery

Change the source to correct syntax and retry the compilation.

SQL 17539

17539 Variable name must be explicitly initialized because it cannot be NULL.

: Where,
name: is the name of the variable that must be assigned an initial value.

Cause

A NOT NULL datatype is not assigned an initial value.

Effect

The operation fails.

Recovery

Change the source to assign an initial value to the variable in error and retry the compilation.

SQL 17540

17540 Cannot assign to FOR loop index: name.

: Where,
name: is the name of the FOR loop index variable.

Cause

An attempt is made to assign a value to a FOR loop index variable.

Effect

The operation fails.

Recovery

Change the source to remove the assignment and retry the compilation.