Before INSERT TRIGGER on table PER_ANALYSIS_CRITERIA give me tichnical error message before and afte
Hi,
i have created Before INSERT TRIGGER on table PER_ANALYSIS_CRITERIA to validate the SIT (Special Information Type) data, and if the validation fails, i am raising error through the following PLSQL:
HR_UTILITY.SET_MESSAGE(800, 'ARABSAT_DUPLICATE_01'); HR_UTILITY.RAISE_ERROR;but the problem is: the raised error message is consists of three parts ( oracle technical error, my mcustom message and oracle technical error )
the complete raised error message:
===========================