OraFAQ Forum: Forms » FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502

Home » Developer & Programmer » Forms » FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502 (oracle Forms 11g (11.1.2))

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

FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502 [message #588572]

Wed, 26 June 2013 10:23

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 1462 times)

Report message to a moderator

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

cookiemonster
Messages: 13920
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.

Report message to a moderator

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

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

Report message to a moderator

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

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

Senior Member
Account Moderator

How does your WHEN-NEW-FORM-INSTANCE trigger look like? What does it do?

Report message to a moderator

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

joy_division
Messages: 4963
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.

Report message to a moderator

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

cookiemonster
Messages: 13920
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.

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	FRM-40654 on some rows only ???
Next Topic:	iconic image with label in button

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 23:39:43 CDT 2024