UNIX for Advanced & Expert Users

I keep getting the error FRM 40735: When button pressed trigger raised unhandled exception. ORA-06502.

The forms builder im using is 9i. I call a function in UNIX through an interface function, which is called by the button in forms.

There is no problem with the interfcace and calls. ut the functions compiled in unix always raises this error.

The functions are all compiled successfully and in the libraries. It ecven works when the nightly program is run. But when we call it through forms, this always raises an error like this. Please Help.

could you please check whether you are assigning NULL to NOTNULL variable
may be such variables are initialized to NULL along with other variables by mistake.

(or)

possible cause of numeric overflow like assigning 1000 to variable of datatype NUMBER(3)