Re: How to determine if a Procedure fails?

[Quoted] 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?
> >
> > I thought about just changing it to a function and on an 'EXCEPTION
> > handler', returning a 1 otherwise returning a zero. But I thought there
> > probably is a better way.
> >
> > I would appreciate some ideas on this.
> >
> > Thanks to all,
> >
> > Ken Halsted.
> >
> > --
> > _________________
> > Kenneth W. Halsted
> > Mountaire Corporation
> > ph: (501) 399-8812
> > url: http://www.mountaire.com
> > email: kenman_at_mail.snider.net
>
> --
> Valeri Sorokine
> 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
Received on Fri Sep 03 1999 - 14:11:40 CEST