Re: How to determine if a Procedure fails?

[Quoted] 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