My Oracle Support Banner

Field Length Issue - DTYPE_NOTE (Doc ID 545331.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Siebel Tools - Version [16084] to 8.1.1 SIA [21111] [Release V7 to V8]
Information in this document applies to any platform.
- - -
Product Release: V7 (Enterprise)
Version: [16084]
Database: Oracle
Application Server OS: Sun Solaris 2.8
Database Server OS: Sun Solaris 2.8

This document was previously published as Siebel SR 38-1436801761.

""Checked for Relevance on 10-Dec-2009""
""Checked for Relevance on 25-Nov-2013""



We have a requirement to have a text field that holds 5000 characters. We have created a new long column on the S_OPTY_X extension table and mapped a new DTYPE_NOTE field to the column.

We have displayed the new field in a form applet with control HTML type = TextArea. Currently, the users are allowed to enter in 16383 characters. We need to limit users to only entering in 5000 characters. We have tried the following:

1. Text Length Override field user prop on the new field. Does not work.

2. HTML attribute (i.e. 'cols=50 rows=3 wrap=hard'). This attribute limits the text area of the box, but does not limit the number of characters. The format of the content will vary, so setting the text area limits is unacceptable.

3. Writing script on PreSetFieldValue using "len(FieldValue)" function. This does not meet the business requirement because it only checks the length AFTER the user steps off the record. The requirement is to limit the user from entering in over 5000 characters.

Please advise on how we can limit the number of characters entered to 5000.



To view full details, sign in with your My Oracle Support account.

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

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.