Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-06502

PL/SQL: value or conversion errorerror_info
  • error_info: A more detailed description of why the error occurred.

Cause

An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if you attempt to assign the value NULL to a variable declared NOT NULL, or if you attempt to assign an integer greater than 99 to a variable declared NUMBER(2).


Action

To resolve the issue, change the data, the way the data is manipulated, or the data variable declaration.