Home » Developer & Programmer » Forms » FRM-30187
FRM-30187 [message #337971] Fri, 01 August 2008 15:34 Go to next message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
Hi,

I got that error bur I checked all the fields on RG query and they are not more 300 char in total. Even I changed the query but I still get this error. Please advice. Thanks
Re: FRM-30187 [message #338015 is a reply to message #337971] Sat, 02 August 2008 05:52 Go to previous messageGo to next message
Littlefoot
Messages: 19823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what Oracle says:
Quote:
FRM-30187: Size of CHAR column in record group must be between 1 and 2000.

Cause:  The size of a character column in the record group was incorrectly specified

Action:  Make sure the sizes of the character columns in the record group are between 1 and 2000


As it is difficult to guess what might be wrong without actually seeing your form, perhaps you could attach the FMB file so that we could take a look.
Re: FRM-30187 [message #568240 is a reply to message #338015] Wed, 10 October 2012 05:54 Go to previous message
simonkimbrell
Messages: 4
Registered: September 2008
Junior Member
If you have used a function to return a value in your record group it defaults to 4000 characters instead of the column size.

The way to fix this is open the LOV column specifications and reduce the column to a more manageable size (ie below 2000)
Previous Topic: Forms 6i
Next Topic: FRM 40508 : unable to insert records
Goto Forum:
  


Current Time: Fri Nov 28 11:08:54 CST 2014

Total time taken to generate the page: 0.08102 seconds