Last updated on SEPTEMBER 19, 2016
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***
We have created a custom table CX_ERROR to store errors details on failed integration transactions. The table definition is included in the attached sif file. There is a requirement 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
The sif and export of the table definition is attached as well as a screen dump of the error messages.
Can you please advise on how to progress with this?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms