Oracle Error ORA-34761: (NXHANDLEALLO) A decimal overflow occurred during an ALLOCATE operation. The results are not reliable.

Oracle Error Message

ORA-34761: (NXHANDLEALLO) A decimal overflow occurred during an ALLOCATE operation. The results are not reliable.

Reason for the Error

While performing an ALLOCATE, a decimal overflow occurred

Solution

Correct the data or use a higher precision datatype