Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How do I get the last error message ?

How do I get the last error message ?

From: Ernest Morariu <ernest_at_gesora.com>
Date: Tue, 3 Aug 2004 09:51:33 +0200
Message-ID: <ceng6a$9mh$1@fata.cs.interbusiness.it>


Hi All!

My trigger do not have to block the current operation on the table, so, in the exception block, I would like to insert a new record in a table called TriggerErrors and to register in this record the last error message.

My problem is how to get last error message ?

BEGIN
if SALOP.IS_EXAM_FOR_RIS(:NEW.ac_ric_code, :NEW.ac_uni_seq)='T' then   RIS.INSERT_STUDY_EVENT('RADExamCreated',:new.AC_RIC_CODE,:NEW.AC_CODE); end if;

Exception
  When others THEN

      RIS.Log_Trigger_Error(:new.AC_CODE,'ExamCreated','>> ?? last error description ?? <<<');
END; Received on Tue Aug 03 2004 - 02:51:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US