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