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

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
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what Oracle says:
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
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 10g installation
Next Topic: Oracle qo g application with web
Goto Forum:

Current Time: Sat Aug 19 12:02:57 CDT 2017

Total time taken to generate the page: 0.05999 seconds