How to set the maximum length of CLOB/LONG columns in generated forms (Doc ID 403980.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Designer - Version 10.1.2.0.2 to 10.1.2.6.18 [Release Designer 10g to AS10gR2]
Information in this document applies to any platform.
This issue will affect forms generation from all versions of Designer 6i, 9i, and 10g.
"Checked for relevance on 13-Aug-2014"


Goal

When generating a Designer forms module that is based on a table with a CLOB column, the default value for its maximum length is being defaulted to 30.  This is despite setting either the item's Maximum Length property, or the TXTDLL (Text item default LONG/LOB length) Forms Generator preference.

According to the online help, Designer will look to see if the Maximum Length property for the item is populated.  If the TXTDLL preference is not set, the Maximum Length property will be used.  If the TXTDLL is populated, it will be used unless an object library is specified at the time of generation in the Generate Form dialog box.  However, if the library does not contain an item to govern the length of CLOB or LONG items, the maximum length will default to 30.

This problem will be evident to developers who use the standard object library OFGWEBOL.OLB, although other standard libraries may result in the same behavior.  If the chosen library does contain an item which governs the length of generated CLOB and LONG items, that value will be used.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms