Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Forms field truncated large text.

3053701Aug 29 2017 — edited Aug 31 2017

Converted the column datatype to CLOB in the table, but the forms field, which is against to this column, still truncated the large file which is more than 50-pages (around 8200 words and 32 KB).

In the forms item Property Palette, set Data Type=LONG or Char (there is no CLOB in the drop list to select). Maximum Length=65534 (forms does not allow to add more than this number such as 65535 or more). Query Length=65534.

In the block property Palette, set Query Data Source Column Type as CLOB for this column.

Any idea, suggestion and/or approach about this is very appreciated.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2017
Added on Aug 29 2017
10 comments
1,334 views