AnsweredAssumed Answered

Raise and capturing error from Oracle trigger

Question asked by crama on Dec 28, 2009
Latest reply on Dec 29, 2009 by sundar
Normally the oracle trigger is created/written using Raise_Application_Error to raise the error.
CREATE OR REPLACE TRIGGER BEFORE_INS_ODF_CA_INCIDENT_T1 

     BEFORE INSERT ON ODF_CA_INCIDENT FOR EACH ROW 

 DECLARE 

 BEGIN 

   /* process go below */  

     … …

     … …

     … …

 

    RAISE_APPLICATION_ERROR(-20001,'Message to display on UI.'); 

 

 END BEFORE_INS_ODF_CA_INCIDENT_T1;

 
The “odf-pmd.20001=Custom-0001: Error message to display on UI” error message is defined in messages_en.properties file and the APP services are restarted after defining the error message. This message will be displayed in the UI screen when the trigger is raised.


But the same trigger process is not working on CLB_DMS_FILES table. The error message is defined in messages_en.properties and also dmserrmsg_en.properties (in WEB-INF folder) files. (The trigger on CLB_DMS_FILE is not provided here because its same defined above)


The error message in messages_en.properties file is "dms.20001=DMS-20001: Message to display on UI page.".


The error message in dmserr_en.properties file is " 21000.Description=Message to display on UI page.

21000.Solution=Message to display on UI page."



Any thoughts please?


Database is Oracle 10g (10.2.0.4)

Clarity : 8.1 fp3 ( or 12 SP0 also)



Thanks

Rama

Outcomes