Home » Developer & Programmer » Forms » FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502 (oracle Forms 11g (11.1.2))
FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502 [message #588572] Wed, 26 June 2013 10:23 Go to next message
mukhtar39
Messages: 6
Registered: May 2013
Junior Member
Hi,

We are migrating forms and reports from 10g to 11g(11.1.2) version.
I'm getting following error when I tried to open the form on web.
"FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502".
All forms are compiled successfully and required PLL's also attached.

Please provide solutions.

Thanks,
Mukhtar
  • Attachment: Error.jpg
    (Size: 138.47KB, Downloaded 132 times)
Re: FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502 [message #588575 is a reply to message #588572] Wed, 26 June 2013 10:55 Go to previous messageGo to next message
cookiemonster
Messages: 11285
Registered: September 2008
Location: Rainy Manchester
Senior Member
06502, 00000, "PL/SQL: numeric or value error%s"
// *Cause:
// *Action:


Find the offending code and fix it.
Re: FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502 [message #588581 is a reply to message #588575] Wed, 26 June 2013 12:21 Go to previous messageGo to next message
mukhtar39
Messages: 6
Registered: May 2013
Junior Member
Hi,

I'm not getting numeric value errors. Forms got successfully compiled both in Form Builder and LInux.
Pls provide solutions.

Thanks,
Mukhtar
Re: FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502 [message #588589 is a reply to message #588581] Wed, 26 June 2013 14:40 Go to previous messageGo to next message
Littlefoot
Messages: 19890
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How does your WHEN-NEW-FORM-INSTANCE trigger look like? What does it do?
Re: FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502 [message #588598 is a reply to message #588581] Wed, 26 June 2013 15:33 Go to previous messageGo to next message
joy_division
Messages: 4559
Registered: February 2005
Location: East Coast USA
Senior Member
mukhtar39 wrote on Wed, 26 June 2013 13:21
I'm not getting numeric value errors. Forms got successfully compiled both in Form Builder and LInux.
Pls provide solutions.


This has nothing to do with compilation. It's a runtime message. You are probably trying to load a varchar into a number or a value is too large for a variable it is being put into.
Re: FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502 [message #588604 is a reply to message #588581] Wed, 26 June 2013 17:09 Go to previous messageGo to next message
cookiemonster
Messages: 11285
Registered: September 2008
Location: Rainy Manchester
Senior Member
mukhtar39 wrote on Wed, 26 June 2013 18:21

I'm not getting numeric value errors.

That is exactly what you are getting unless you typed the wrong error number in your first post.
Re: FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502 [message #588695 is a reply to message #588604] Thu, 27 June 2013 08:01 Go to previous message
mukhtar39
Messages: 6
Registered: May 2013
Junior Member
My issue has been resolved now. The issue is I'm trying to load lager value into variable. So increased the variable size.

Thank You All.
Previous Topic: FRM-40654 on some rows only ???
Next Topic: iconic image with label in button
Goto Forum:
  


Current Time: Sat Dec 20 20:11:01 CST 2014

Total time taken to generate the page: 0.04199 seconds