Hi Guys,
Can anyone tell me the values of keep_errors in RAISE_APPLICATION_ERROR like as per the documentation the syntax of the raise_application_error is RAISE_APPLICATION_ERROR(ERROR_NUMBER,ERROR_MESSAGE,KEEP_ERRORS) where the error no is the number between -20000 and -20999 and the error message is the user defined message and keep_errors is the boolean value if it is true then the error will be added to the error stack other wise it will purge the stack and add the recent error.
however when I am using this i am getting the following error,Please suggest if any body has any better solutions to use this
Declare
begin
If 200 > 100 Then
Raise_Application_Error (-20001,'The if condtion is fine','TRUE');
End If;
END ;
Below is the error I am getting
Error starting at line 1 in command:
Declare
begin
If 200 > 100 Then
Raise_Application_Error (-20001,'The if condtion is fine','TRUE');
End If;
END ;
Error report:
ORA-06550: line 7, column 7:
PLS-00306: wrong number or types of arguments in call to 'RAISE_APPLICATION_ERROR'
ORA-06550: line 7, column 7:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
Regards,
Ranjan