OraFAQ Forum: Forms » frm-40508 error

Home » Developer & Programmer » Forms » frm-40508 error

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

frm-40508 error [message #142713]

Mon, 17 October 2005 06:47

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

Report message to a moderator

Re: frm-40508 error [message #142815 is a reply to message #142713]

Mon, 17 October 2005 18:28

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: frm-40508 error [message #142937 is a reply to message #142713]

Tue, 18 October 2005 08:01

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

Report message to a moderator

Re: frm-40508 error [message #143060 is a reply to message #142937]

Tue, 18 October 2005 23:43

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

tamim13
Messages: 1
Registered: February 2007

Junior Member

Thanks for the help djmartin, the link gave me exactly what I wanted.

Report message to a moderator

Previous Topic:	Forms Size
Next Topic:	.fmx file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 18:40:36 CST 2025