I am getting the error "ORA-00932: inconsistent datatypes: expected - got CLOB" when using iBATIS .NET to execute a select that returns several CLOB-type columns. I have tried each of the following three syntaxes in my resultMap/constructor/argument nodes:
I started with the simplest form, which is how everything else is defined: <argument argumentName="testResultTableNote" column="TEST_RESULT_TABLE_NOTE"/> But then I tried these, based on paragraph 3.5.3.4 in the v1.6.1 documentation, which explicitly states that this may be necessary for CLOB or DATE data-types: <argument argumentName="testResultTableNote" column="TEST_RESULT_TABLE_NOTE" dbType="CLOB"/> <argument argumentName="testResultTableNote" column="TEST_RESULT_TABLE_NOTE" dbType="CLOB" type="string"/> All of them result in the same error. So I chased down table 3.5 in the v1.6.1 docs and I find that the OracleType column doesn't actually list CLOB anywhere. Is this something that is going to require a custom type handler to work, or am I doing something wrong above? Tony
