My Oracle Support Banner

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 APRIL 30, 2018

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


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


To view full details, 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 a vibrant support community of peers and Oracle experts.