OraFAQ Forum: Forms » failure of on-error trigger

Home » Developer & Programmer » Forms » failure of on-error trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

failure of on-error trigger [message #375711]

Mon, 11 December 2000 09:49

AJAY.K
Messages: 2
Registered: December 2000

Junior Member

I am working with forms 6 and even if try to trap error
number frm-40301 from on-error on form level for query retrived no records in enter_query mode nothing is happening.I would be very thankful if some one can tell me what's wrong.this is my code unit

DECLARE
errnum NUMBER := ERROR_CODE;
alert_button number;
BEGIN
IF :System.Mode = 'ENTER-QUERY' AND errnum = 40301 THEN
Set_Alert_Property('alert1', ALERT_MESSAGE_TEXT, 'Query returned no records');
alert_button := show_alert('alert1');
RAISE FORM_TRIGGER_FAILURE;
END IF;
END;

Thanking you

Ajay.k

Report message to a moderator

Previous Topic:	Installing Developer 6.0
Next Topic:	how to pass parameter with run_product

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 31 16:49:23 CST 2025