DB2 Error Code 932 – ORA-00932: inconsistent datatypes: expected – got CLOB

In this post, you’ll learn about the DB2 error 932-ORA-00932: inconsistent datatypes: expected – got CLOB and the reason why you are receiving the error message and how to fix it

How does this Error Message Looks like

932 – ORA-00932: inconsistent datatypes: expected – got CLOB

Reason for the Error & Solution

A normal string field was mapped to an Oracle CLOB type. Oracle requires special handling for CLOBs. Ensure that the column for this field specifies a jdbc-type of clob or a length of -1.