Re: Forms 4.5 Procedures

u can trap the database ora errors in ur on error trigger

if sqlcode = 942 then etc..

u also have dbms_error_code and dbms_error text for the description of the error messages

HTH
Arvind

Manjula Krishnan wrote:

> I have a database procedure to insert some records in a table. This is
> called on the WHEN-BUTTON-PRESSED trigger of a non-basetable form.
>
> How can I pass the error messages from a database procedure back to the
> forms, when the form calls the procedure in a trigger?
>
> Thanks,
>
> Manjula

--
Balaraman Arvind
151 Andrew Ave, Apt 215
Naugatuck, CT 06770

ph   -  (203)-723-1190(R)
     -  (203)-459-7502(O)

mail -  dnivra_at_ix.netcom.com (R)
        abalaram_at_oxhp.com    (O)