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.
Last updated on FEBRUARY 20, 2018
Applies to:Siebel Tools - Version 7.5.3  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3 
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***
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:
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
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