Error When Searching Assets in CA: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB
(Doc ID 2036149.1)
Last updated on SEPTEMBER 07, 2023
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):
Or this error in the log (in this case the problem was with promotions):
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |