Home » Developer & Programmer » Forms » frm-40508 error
frm-40508 error [message #142713] Mon, 17 October 2005 06:47 Go to next message
supriya_546
Messages: 56
Registered: October 2005
Location: hyderabad
Member
Hi,

frm-40508 unable to insert the record.
this error occurs because of soooooo many reasons.
in my form i am getting this error because of field length,
its size is longer than database field size.
how to catch only this error in on-error trigger.

under frm-40508 how to catch only field length error.
its database error is ora-1401.

is there any way to catch this one directly.

thank u
supriya

Re: frm-40508 error [message #142815 is a reply to message #142713] Mon, 17 October 2005 18:28 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why catch it? Why not define your form field to match the database length? Make your user's life easier and let forms STOP them inserting the extra characters instead of giving a useless message like "Your data is too long".

David
Re: frm-40508 error [message #142937 is a reply to message #142713] Tue, 18 October 2005 08:01 Go to previous messageGo to next message
supriya_546
Messages: 56
Registered: October 2005
Location: hyderabad
Member
Hi David,
i am upgrading forms 8th version to 9th version.
we have some standards that form field size should be 3 times the database field.
& i changed all varchar2 types to nvarchar2.
i must follow this this standard.
this all doing for language support (unicode charecters).

thank u
supriya

Re: frm-40508 error [message #143060 is a reply to message #142937] Tue, 18 October 2005 23:43 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at http://www.orafaq.com/forum/m/134994/67467/?srch=error_code#msg_134994. If you want other entries search the forum for 'error_code' and maybe 'dbms_error_code'.

David

[Updated on: Tue, 18 October 2005 23:44]

Report message to a moderator

Re: frm-40508 error [message #220250 is a reply to message #143060] Mon, 19 February 2007 21:01 Go to previous message
tamim13
Messages: 1
Registered: February 2007
Junior Member
Thanks for the help djmartin, the link gave me exactly what I wanted.
Previous Topic: Forms Size
Next Topic: .fmx file
Goto Forum:
  


Current Time: Thu Dec 08 00:05:22 CST 2016

Total time taken to generate the page: 0.06553 seconds