Home » Developer & Programmer » Forms » FRM-40735
FRM-40735 [message #207345] Tue, 05 December 2006 03:56 Go to next message
developpeur
Messages: 3
Registered: December 2006
Junior Member
Hi,

while Iam generate file excel in form ( form 6i and Excel 2003)
But iam gettng error as follows:

FRM-40735 WHEN-BUTTON-PRESSED TRIGGER RAISED AN UNHANDLED EXCEPTION ORA-302000.

Could any one tell me how to go about it?
Re: FRM-40735 [message #207354 is a reply to message #207345] Tue, 05 December 2006 04:15 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
hi,

i think you should use an exception and try to catch an error ...

Bye
Ashu
Re: FRM-40735 [message #207361 is a reply to message #207345] Tue, 05 December 2006 04:31 Go to previous messageGo to next message
developpeur
Messages: 3
Registered: December 2006
Junior Member
while i use exception :
Exception when others then ret:=('ERROR');

iam getting error as follows:

frm-40735: when-button-pressed trigger raised unhandled exception ora-06502
Re: FRM-40735 [message #207365 is a reply to message #207361] Tue, 05 December 2006 04:36 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
in the exception print some message or sqlerrm to get the message

to rectify error see the datatype you declared and what you are receiving ...

bye
ashu

[Updated on: Tue, 05 December 2006 04:40]

Report message to a moderator

Re: FRM-40735 [message #207366 is a reply to message #207361] Tue, 05 December 2006 04:37 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Numeric error??

Check for size overflow and datatype mismatch.

By
Vamsi
Re: FRM-40735 [message #207422 is a reply to message #207345] Tue, 05 December 2006 08:33 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Try here:

http://www.oracle.com/pls/db92/db92.error_search?search=ORA-06502
Re: FRM-40735 [message #207424 is a reply to message #207345] Tue, 05 December 2006 08:46 Go to previous messageGo to next message
developpeur
Messages: 3
Registered: December 2006
Junior Member
OK
THINKS
Re: FRM-40735 [message #207920 is a reply to message #207345] Thu, 07 December 2006 06:12 Go to previous message
kbhujendra@rediffmail.com
Messages: 26
Registered: June 2006
Location: Hyderabad,India
Junior Member

Hi,

Can you please paste your code here?
so that I understand what is the problem in your code.


Bhujendra
Previous Topic: Need Forms PDF Materials
Next Topic: trigger event problem for dynamic list item
Goto Forum:
  


Current Time: Sat Dec 03 18:09:22 CST 2016

Total time taken to generate the page: 0.12936 seconds