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

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