Home » Developer & Programmer » Forms » frm-40831
frm-40831 [message #170382] Wed, 03 May 2006 08:58 Go to next message
Messages: 25
Registered: April 2006
Location: india
Junior Member
hello everybody,

i've a problem. when i run one of my forms a form builder error(frm- 40831) is being displayed saying 'Truncation occured. Value too long for field xxxx'. i tested and found that there is no wrong with the field i've chosen in my form.

can any body pls help me.
thanks in advance.
Re: frm-40831 [message #170443 is a reply to message #170382] Wed, 03 May 2006 21:22 Go to previous messageGo to next message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Oracle doesn't issue this sort of message just for the hell of it. Use "message / pause" pairs to determine EXACTLY the line giving the error. Then check the length of the recipient item in your form AND the length of the column in your database to which this item is matched.

Re: frm-40831 [message #360091 is a reply to message #170382] Wed, 19 November 2008 10:09 Go to previous message
Messages: 1
Registered: November 2008
Location: Toronto
Junior Member
This is the fix for this problem.
(Especially if you are using Index Organized Tables)

FRM-40831 When querying from Indexed Organised Table in Forms

Problem Description:
Performing a query in Forms, which is referring to an indexed organised table, with a longer rowid causes FRM-40831 - value too long for field ROWID. Though the query gets successfully executed with rowid full (No Truncation).

Solution Description
Change block property Key Mode to Updatable or Non-Updatable and set item property Promary Key to Yes for all items that correspond to an index column in
the index-organized table.
Previous Topic: How to send ParameterList into WEB.SHOW_DOCUMENT()
Next Topic: Remapping other then F0-F9 keys in Form6i
Goto Forum:

Current Time: Thu Jul 27 19:43:40 CDT 2017

Total time taken to generate the page: 0.10015 seconds