OraFAQ Forum: Forms » How to display alert message in Forms 9i.

Home » Developer & Programmer » Forms » How to display alert message in Forms 9i.

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

How to display alert message in Forms 9i. [message #267677]

Fri, 14 September 2007 03:47

kelvinora
Messages: 16
Registered: September 2007
Location: India

Junior Member

Hi
How to display alert message in Forms 9i.
The alert box is same as Javascript alert?
or anyother things?
Thanks,

Report message to a moderator

Re: How to display alert message in Forms 9i. [message #267678 is a reply to message #267677]

Fri, 14 September 2007 03:56

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Check this OraFAQ topic.

Report message to a moderator

Re: How to display alert message in Forms 9i. [message #267688 is a reply to message #267678]

Fri, 14 September 2007 04:50

kelvinora
Messages: 16
Registered: September 2007
Location: India

Junior Member

I had tied to display alert message in the form..

But it shows FRM-41039: Invalid alert ID 0 - my alert(s) do not display ..

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;

Report message to a moderator