New Table Column of Type Varchar 4000 in Tools is Implemented as Column of Type LONG in the Database

(Doc ID 977517.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1 [21112] and later
Information in this document applies to any platform.
Checked for Relevance on 05-Oct-2015

Symptoms

Customer created custom extension column with Varchar as Physical Type and 4000 as Length. When they tried to apply this schema change to their Oracle server database they received the following errors:
- - -
UTLDbDdlDbMerge
pOperCallback UTLDbDdlOperMultiColAdd
SQL Error Adding multiple column in one batch ... 26
S1000 (1754): [DataDirect][ODBC Oracle driver][Oracle]ORA-01754: a table may contain only one column of type LONG
- - -

The Bookshelf version 8.0 mentions however that it is possible to create a column of type Varchar(4000):

Configuring Siebel Business Applications
Configuring Tables and Columns
Adding Extension Columns to Base Tables
- - -
...
When adding columns to tables, consider the following:
...
For Oracle databases, the maximum length of extension columns with data type of VARCHAR is 4000 characters. If you create a column of type VARCHAR that is longer than 4000, it is automatically implemented as a column with data type of LONG.
...
- - -

Cause

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