Home » Developer & Programmer » Forms » WHEN-NEW-FORM-Instance trigger (Developer 2000, PL/SQL, Windows XP)
WHEN-NEW-FORM-Instance trigger [message #588957] Mon, 01 July 2013 00:13 Go to next message
Messages: 5
Registered: June 2013
Location: Jammu
Junior Member


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.

Re: WHEN-NEW-FORM-Instance trigger [message #588959 is a reply to message #588957] Mon, 01 July 2013 00:50 Go to previous message
Messages: 21146
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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.
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:

Current Time: Thu Aug 17 16:42:50 CDT 2017

Total time taken to generate the page: 0.07698 seconds