Oracle Database Errors or Warnings from Error ORA-21707 to ORA-22056

SQLServerF1

ORA-21707: pin duration is longer than allocation duration
Cause: The pin duration supplied by the user is longer than the allocation duration. This affects operations such as pinning and setting default parameters.
Action: User should use a shorter pin duration or use the null duration.
ORA-21708: inappropriate operation on a transient object
Cause: User attempted to perform an inappropriate operation on a transient object. Operations that cannot be applied to a transient object include flushing and locking.
Action: User should avoid performing such operation on a transient object.
ORA-21709: cannot refresh an object that has been modified
Cause: User attempted to refresh an object that has been marked for delete, update or insert (new).
Action: User should unmark the object before refreshing it.

ORA-21710: argument is expecting a valid memory address of an object
Cause: The object memory address that is supplied by the user is invalid. The user may have passed in a bad memory address to a function that is expecting a valid memory address of an object.
Action: User should pass in a valid memory address of an object to the function.
ORA-21779: duration not active
Cause: User is trying to use a duration that has been terminated.
Action: User should avoid performing such operation.
ORA-21780: Maximum number of object durations exceeded.
Cause: This typically happens if there is infinite recursion in the PL/SQL function that is being executed.
Action: User should alter the recursion condition in order to prevent infinite recursion.

ORA-22053: overflow error
Cause: This operation’s result is above the range of Oracle number.
Action: Decrease the input value(s) so that the result is in the range of Oracle number.
ORA-22054: underflow error
Cause: This operation’s result is below the range of Oracle number.
Action: Increase the input value(s) so that the result is in the range of Oracle number.
ORA-22055: unknown sign flag value [string]
Cause: Signed flag used is not OCI_NUMBER_SIGNED or OCI_NUMBER_UNSIGNED.
Action: Use either OCI_NUMBER_SIGNED or OCI_NUMBER_UNSIGNED as sign flag.
ORA-22056: value [string] is divided by zero
Cause: Given value is divied by zero.
Action: Modify divisor value to be non-zero.

Above are list of Oracle Database Errors or Warnings from Error ORA-21707 to ORA-22056 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *