[Fix]-Regarding ORA 21000

Wikitechy | 3015 Views | oracle | 26 May 2016

 

ORA-21000: error number argument to raise_application_error of 3739 is out of range.

Scenario:

This error occurs occasionally. This worked fine earlier, but after migrating to Linux from Solaris , error occurs as 

Fix for this issue

Reason for the error:

RAISE_APPLICATION_ERROR is a methodology to shoot up custom errors in Oracle. It is a procedure that takes an error number argument between the range -20000 to -20999.

Fix:

Since the number 3739 is not in this range, there must surely be some defect in the application.



Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise