Hi,
I have a database procedure which is doing a series of validations. Where the validation fails, I have put in a raise_application_error call with a custom error message. I am calling this in PRE-FORM trigger of the form and would like to display the custom error message. I have managed to display something (not the exact error message) using the message(sqlerrm) statement. But this shows a lot of other junk as well like the error number associated with the custom error at the beginning of the message & the entire stack at the end of the custom error - something like
ora-20001: <<custom message>>. ora-06512: at <<package.procedure_name>>, line 100
Is there a way by which I can display only the user-defined message without sending the message text back to the form as a return value OUT parameter or re-coding the message in the form
thanks
Parag