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 AUGUST 01, 2023

Applies to:

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.
...
- - -

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.