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 -> Re: How do I get the last error message ?

Re: How do I get the last error message ?

From: Ernest Morariu <ernest_at_gesora.com>
Date: Tue, 3 Aug 2004 11:20:02 +0200
Message-ID: <cenlc6$lad$1@balena.cs.interbusiness.it>

Thanks a lot Michel ! You helped very much .

Best Reagards,
Ernest

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:410f4f26$0$1888$636a15ce_at_news.free.fr...
>
> "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
>
>
Received on Tue Aug 03 2004 - 04:20:02 CDT

Original text of this message

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