Error When Searching Assets in CA: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB (Doc ID 2036149.1)

Last updated on DECEMBER 17, 2015

Applies to:

Oracle Commerce Platform - Version 10.0 to 10.2.0.5 [Release 10]
Information in this document applies to any platform.

Symptoms

When searching in the Content Administration assets search area we receive a ORA-00932 error. This does not happen within the Find section in the Merchandising area.

For example, you may see this kind of error in the Content Administration user interface (in this case the problem was with an asset of type product):

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