Re: ON-MESSAGE TRIGGER

Hi Praveen !

Thanks 4 taking the time to reply.

Just receive all the Oracle-L Digest from 20 Dec to 24 Dec this morning. Yesterday, was just complaining to my colleague regarding Oracle-L List gone dead.

Anyway, a few days ago, I tried using the ON-ERROR trigger, it works.

ChorLing
chancl_at_nievax.nie.ac.sg

PS. Nowadays, everytime I send a mail to ORACLE-L List, it bounces back. Yet, a few days later, when I receive the ORACLE-List digest, it will be there. Those of U who know why, pls send a mail to me. TIA

> From: "Praveen K. Gopu" on 22 Dec 95
>
> You should trap the error using PRGMA EXCEPTION INIT if it is a
> ORA error and ifit is a FRM error check the on-message trigger at
> field, or form level. I hope this infor. helps you.
> (snip)
>

> From Sridhar
> For error messages, use ON-ERROR trigger with the alert logic in it.

> From ChorLing on 21 Dec 95
> I would like to capture the err msg and display an alert
> to my user as some 'older' user feels that the msg displayed on the
> msg line is too.. . too small. <snip>
Received on Wed Dec 27 1995 - 00:15:55 CST