After all validations when i submit my page there are some validations that work in Trigger and hence hen they fail it shows error like
ORA-20000: Cannot drop object ORA-06512: at "schema.CHECK_ERROR", line 2 ORA-04088: error during execution of trigger 'schema.CHECK_ERROR'
when i add #SQLERRM_TEXT# in Error Message of the DML Process.
then the error message shows like
Cannot drop object ORA-06512: at "schema.CHECK_ERROR", line 2 ORA-04088: error during execution of trigger 'schema.CHECK_ERROR'
I want my final output be like Cannot drop object.
And as there are many errors like this in my trigger hence i cannot write all of it into Page validation.
Please help
Thank You in advance.