Oracle8 Error Messages
Release 8.0.4

A58312-01

Library

Product

Contents

Index

Prev Prev Next

21700-21799: KOC (cache) Messages

ORA-21700: object does not exist or has been deleted

Cause: An attempt was made to perform an inappropriate operation to a deleted or non-existent object that is referenced by a dangling reference. Operations that cannot be applied to a non-existent or deleted object include deleting, updating and allocating memory.

Action: Re-initialize the reference in order to reference an existent object before performing the operation.

ORA-21701: object has been purged

Cause: An attempt was made to perform an inappropriate operation to an object that is marked purged. The actual object could have been modified in the database. Operations that cannot be applied to a purged object includes updating, deleting and flushing.

Action: Pin the object again to get the new data.

ORA-21702: object is not instantiated in the cache

Cause: An attempt was made to perform an inappropriate operation to a transient object that is not instantiated in the object cache. Operations that cannot be applied to a not-instantiated transient object include deleting or pinning such an object.

Action: Check the code to see if operations are being performed without instantiating the object first, or operations are being performed after the allocation duration of the object has expired.

ORA-21703: cannot flush an object that is not modified

Cause: The object could not be flushed because it has not been modified.

Action: The object should not be flushed.

ORA-21704: terminate cache or connection without flushing

Cause: See the error message.

Action: The transaction should be aborted or committed before terminating the cache or connection.

ORA-21705: service context is invalid

Cause: An attempt was made to supply a service context that is not valid.

Action: Establish the service context and retry the operation.

ORA-21706: duration does not exist

Cause: An attempt was made to supply a duration number that is not valid.

Action: Establish the duration or use a correct predefined duration.

ORA-21707: the pin duration is longer than the allocation duration

Cause: An attempt was made to supply a pin duration that is longer than the allocation duration. This affects operations such as pinning and setting default parameters.

Action: Use a shorter pin duration or use the null duration.

ORA-21708: operations cannot be performed on a transient object

Cause: An attempt was made to perform an inappropriate operation on a transient object. Operations that cannot be applied to a transient object include flushing and locking.

Action: Avoid performing operations such as flushing and locking on a transient object.

ORA-21709: operations can only be performed on a current object

Cause: An attempt was made to perform an inappropriate operation on a not-current object. Operations that cannot be applied to a not-current object include locking, updating, deleting and flushing.

Action: Avoid performing locking, updating, deleting or flushing operations on a not-current object.

ORA-21710: magic number mismatch

Cause: An attempt was made to supply an invalid object. A bad pointer might have been passed to the object or else a value might have been passed to a function that is expecting an object.

Action: Ensure that a valid pointer or a valid value is passed to the function.

ORA-21779: duration not active

Cause: An attempt was made to use a duration that has been terminated.

Action: Do not use terminated durations in operations.

ORA-22000: variable-length string size of num bytes is outside valid range num to num bytes

Cause: An attempt was made to pass a variable-length string which is outside the valid range.

Action: Specify a string size which is within the valid range and retry the operation.

ORA-22053: overflow error

Cause: The number is too large to be represented by Oracle number.

Action: The operation is beyond the range of Oracle number.

ORA-22054: underflow error

Cause: Number is too small to be represented by Oracle number.

Action: The operation is beyond the range of Oracle number.

ORA-22055: unknown sign flag value [name]

Cause: The signed flag that was used is not ORLTSB or ORLTUB as defined in ORL.H.

Action: Use either ORLTSB or ORLTUB as the sign flag.

ORA-22056: value [num] is divided by zero

Cause: A divide by zero operation has occurred.

Action: Modify the invalid operation and reissue the command.

ORA-22057: bad integer length [num]

Cause: An attempt was made to convert an integer of invalid length (that is, number of bytes) to or from an Oracle number.

Action: Use an integer length of 1, 2, 4 or 8 bytes only.

ORA-22059: buffer size [num] is too small - [num] is needed

Cause: The buffer to hold the text string which wa to be converted from an Oracle number is too small.

Action: Use a buffer size at least that suggested in the error message and retry the operation.

ORA-22060: argument [num] is an invalid or uninitialized number

Cause: An invalid or uninitialized number was passed to a function.

Action: Call kolnini() to initialize a number before using it.

ORA-22061: invalid format text [num]

Cause: An invalid numeric format string was used to convert characters to or from an Oracle number.

Action: See format specification in the description of the TO_NUMBER conversion function in the PL/SQL User's Guide and Reference.

ORA-22062: invalid input string [name]

Cause: An invalid text string was used for converting to numbers.

Action: Use a valid input string and retry the operation.

ORA-22063: reading negative value [num] as unsigned

Cause: An attempt was made to convert a negative number to an unsigned integer.

Action: Use the sign flag ORLTSB to convert a signed number.

ORA-22064: invalid NLS parameter string [name]

Cause: An invalid parameter string was used to convert characters to or from an Oracle number.

Action: See format specification under the TO_NUMBER conversion function in the PL/SQL User's Guide and Reference.

ORA-22065: number to text translation for the given format causes overflow

Cause: Rounding done due to the given string format causes overflow.

Action: Change the string format such that overflow does not occur.

ORA-22130: given buffer size num is less than the required size of num

Cause: An attempt was made to write a hexadecimal REF string into a buffer which is too small.

Action: Provide a buffer of the required size and retry the operation.

ORA-22131: given hexadecimal string length num is not valid

Cause: An attempt was made to give a hexadecimal string a length of zero or less.

Action: Specify a hexadecimal string length greater than zero.

ORA-22132: given hexadecimal string does not correspond to a valid REF

Cause: The given hexadecimal string is invalid.

Action: Use the orlr2h() function for the value to obtain a valid hexadecimal string. Then retry the operation.

ORA-22140: given size num must be in the range of 0 to num

Cause: The given resize size is invalid.

Action: Ensure that the given size is in the required range.

ORA-22150: variable-length array has not been initialized

Cause: An attempt was made to operate on an un-initialized variable-length array.

Action: Use the kolaini() function to initialize the variable-length array before performing an operation on it.

ORA-22151: cannot resize non-zero variable-length array to zero elements

Cause: An attempt was made to resize a non-zero variable-length array to 0 elements.

Action: Do not perform this operation on a non-zero variable-length array.

ORA-22152: destination variable-length array is not initialized

Cause: An attempt was made to use a non-initialized variable-length array on the right-hand-side of an assignment (kolasg()) or as the destination array of an append.

Action: Use the kolaini() function to initialize the variable-length array, then retry the operation.

ORA-22153: source variable-length array is not initialized

Cause: An attempt was made to use a non-initialized variable-length array on the left-hand-side of an assignment (kolasg()) or the as the source array of an append (kolapp()).

Action: Use the kolaini() function to initialize the variable-length array, then retry the operation.

ORA-22160: element at index name does not exist

Cause: An attempt was made to use a collection element at an index which does not exist.

Action: Specify the index of an element which exists, then retry the operation.

ORA-22161: type code name is not valid

Cause: An invalid type code was used.

Action: Consult the ORO.H file for valid type codes.

ORA-22162: element at index name has been previously deleted

Cause: An attempt was made to access a collection element which does not exist at the given index.

Action: Check for the existence of the element prior to calling the function. Then retry the function.

ORA-22163: left hand and right hand side collections are not of same type

Cause: An attempt was made to use left hand and right hand side collections that are not of the same type.

Action: Ensure that the same collection type is passed for both left hand and right hand side of the operation (for example, ASSIGNMENT).

ORA-22164: DELETE ELEMENT operation is not allowed for VARRAYs

Cause: An attempt was made to delete an element of a VARRAY.

Action: Do not perform the DELETE ELEMENT operation on collections of type VARRAY. Ensure that the collection is not of type VARRAY prior to calling this function. Then retry the function.

ORA-22165: given index name must be in the range of 0 to num

Cause: An attempt was made to use an index not in the required range.

Action: Change the index so that it is in the required range, then retry the operation.

ORA-22166: collection is empty

Cause: An attempt was made to use an empty collection.

Action: Test to see if the collection is empty prior to invoking this function.

ORA-22167: given trim size num must be less than or equal to num

Cause: An attempt was made to use a trim size which is greater than the current collection size.

Action: Assign a trim size less than or equal to the collection size, then retry this function.




Prev

Top

Next
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index