My Oracle Support Banner

Publish fails with "ORA-02263: need to specify the datatype for this column" and a missing NUMERIC datatype in sql (Doc ID 1637893.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Sites - Version 7.5.0 and later
Information in this document applies to any platform.

Symptoms

Mirror site configuration from Dev to UAT fails with error:

[2014-03-04 17:05:18.616][CS.DB][ERROR] SQLException executing statement: CREATE TABLE AZ_Info_C_Mungo (id NUMBER(38) PRIMARY KEY NOT NULL, cs_ownerid NUMBER(38) NOT NULL, cs_assetgroupid NUMBER(38) NULL, urlvalue VARCHAR(128) NULL, stringvalue VARCHAR(2000) NULL, intvalue NUMBER(10) NULL, floatvalue NUMBER(38, 10) NULL, moneyvalue NULL, datevalue TIMESTAMP NULL, assetvalue NUMBER(38) NULL, textvalue CLOB NULL, cs_attrid NUMBER(38) NOT NULL, cs_islegal CHAR(1) NULL, blobvalue NUMBER(38) NULL, cs_filterid NUMBER(38) NULL, cs_ordinal NUMBER(38, 10) NULL)
java.sql.SQLSyntaxErrorException: ORA-02263: need to specify the datatype for this column

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.