OraFAQ Forum: Forms » WHEN-NEW-FORM-Instance trigger

Home » Developer & Programmer » Forms » WHEN-NEW-FORM-Instance trigger (Developer 2000, PL/SQL, Windows XP)

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

WHEN-NEW-FORM-Instance trigger [message #588957]

Mon, 01 July 2013 00:13

smehta25
Messages: 5
Registered: June 2013
Location: Jammu

Junior Member

Hi,

Whenever after compilation, I am running the form following error is coming on the window:

FRM-40735: WHEN-NEW-FORM-Instance trigger raised unhandled exception ORA-06502

And after selecting the values following error is coming:

FRM-40738: Argument 1 to builtin SET_ALERT_BUTTON_PROPERTY cannot be null.

Please help in resolving the same.

I am attaching the corresponding .fmb file.

Regards,
Seerat

Attachment: HLVF_EL_CRD.fmb
(Size: 80.00KB, Downloaded 1274 times)

Report message to a moderator

Re: WHEN-NEW-FORM-Instance trigger [message #588959 is a reply to message #588957]

Mon, 01 July 2013 00:50

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

Senior Member
Account Moderator

Oracle

PL/SQL: numeric or value errorstring

Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).

Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.

As of another error, check the way you are using SET_ALERT_BUTTON_PROPERTY built-in.

Report message to a moderator

Previous Topic:	Oracle Forms saving problem
Next Topic:	Check Box. When multi-record block is unchecked then the Select_ALL checkbox should be unchecked.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 01:19:06 CST 2025