My Oracle Support Banner

Tools Apply fails with ORA-01754: a table may contain only one column of type LONG for a Table with one Long column and one Varchar column with a length over 200 Characters. (Doc ID 485281.1)

Last updated on FEBRUARY 20, 2018

Applies to:

Siebel Tools - Version 7.5.3 [16157] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3 [16157]
Database: Oracle 9i
Application Server OS: Microsoft Windows 2000 Advanced Server SP 3
Database Server OS: HP-UX 11i

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

Checked for Relevance 05-Jan-2014
***Checked for Currency on 25/06/16***

Symptoms

Created a custom table CX_ERROR to store errors details on failed integration transactions.

The requirement is: to have a varchar(4000) field for the error message and a 'Long' type field. When applying the changes to Oracle, the error encountered is as follows:

UTLDbDdlDbMerge
pOperCallback UTLDbDdlOperTblCreate
SQL Error Creating table CX_ERROR
HY000 (1754): [DataDirect][ODBC Oracle driver][Oracle]ORA-01754: a table may contain only one column of type LONG


Cause

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
Symptoms
Cause
Solution

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