Re: How to determine if a Procedure fails?

Are you sure?

Why don't you use DBMS_ERROR_CODE and DBMS_ERROR_TEXT in your ON-ERROR trigger?

Hope this helps a little bit.

Internet Anwender wrote:
>
> And it doesn't even matter what you type as '...Your error message...'
> You'll never see it (in FORMS 5) !
> But at least the error will be raised...
>
> til
>
> Valeri Sorokine wrote:
>
> > Hi Ken,
> >
> > Try to use something like this:
> >
> > Raise_Application_Error(-20001, '...Your error message...');
> >
> > Hope this helps.
> >
> > Regards,
> > Valeri
> >
> > Ken Halsted wrote:
> > >
> > > To: Faithful newsgroup
> > >
> > > I was wondering,
> > >
> > > Is there a way to determine if a STORED PROCEDURE fails when calling from a
> > > Forms 5 app?

<skip>

-- 
Valeri Sorokine
[Quoted] ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru