Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FRM-41039: Invalid alert ID 0 - my alert is not displayed

senthilmcaSep 14 2007 — edited Sep 14 2007
Hi
I had tied to display alert message in the form..

But it shows FRM-41039: Invalid alert ID 0 - my alert is not displayed ..

The below is my function..

FUNCTION ALERT_SHOW(message VARCHAR2,showmsg VARCHAR2)
RETURN NUMBER IS alert_no NUMBER;
BEGIN
Set_Alert_Property(message,ALERT_MESSAGE_TEXT,showmsg);
alert_no:= show_alert(message);
RETURN alert_no;
END;

The trigger code is as follows..

DECLARE
ALERT_ID NUMBER;
BEGIN
ALERT_ID:=ALERT_SHOW('ERROR','hai');
raise form_trigger_failure;
END;

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2007
Added on Sep 14 2007
1 comment
819 views