My Oracle Support Banner

While Importing Promotions Using StartSQLImport get Error "java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB" (Doc ID 1677795.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Commerce Platform - Version 11.0 and later
Information in this document applies to any platform.

Symptoms

You are on ATG 11

You have exported out the CRS product catalog using startSQLRepository and are trying to import it in using startSQLImport in ATG 11.0.

However you are getting an error when importing promotions:

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
References


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