Re: How do I get the last error message ?

"Ernest Morariu" <ernest_at_gesora.com> a écrit dans le message de news:ceng6a$9mh$1_at_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;
>
>
>

Have a look at:

sqlcode
sqlerrm
dbms_utility.format_call_stack

--
Regards
Michel Cadot