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 FEBRUARY 07, 2019

Applies to:

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


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:


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

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