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 SEPTEMBER 19, 2016

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

Dear Supportweb,


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:

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

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?

Thanks.

Cause

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