Menu
I am struggling with an ORA 21000 which says ORA-21000: error number argument to raise_application_error of 3739 is out of range.
This error is coming intermittently. I am not sure why this is occurring. This worked absolutely fine earlier, but after migrating to Linux from Solaris, this error has suddenly come up. Googling it didn't help. Please help.
Thanks in Advance.
612
You could correct this error by redefining the v_number variable as number(3). SQL> CREATE OR REPLACE PROCEDURE TestProc 2 AS 3 v_number number(3); 4 BEGIN 5 v_number := 100; 6 END; 7 / Procedure created. And now when we execute our TestProc procedure, the ORA-06512 error has been resolved.
The RAISE_APPLICATION_ERROR procedure accepts user-defined error-number values from -20000 to -20999. The SQLCODE that is returned in the error message is SQL0438N. The SQLSTATE contains class 'UD' plus three characters that correspond to the last three digits of the error-number value.
RAISE_APPLICATION_ERROR is a method by which an application can raise a custom error in Oracle, which is why there will be no documentation about your error message.
This procedure accepts an error number argument, which must be in the range -20000 to -20999. Looks like your application is trying to raise 3739 which is not allowed.
This is a defect in your application.
133
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
