Page 1 of 1

ORA-00932: inconsistent datatypes: expected - got CLOB

Posted: Mon 17 Mar 2014 09:53
by dumian
Hi Team,
we have an strange error using devart version: 8.2.103.0 and XMLTYPE using oracle db version 11.2.0.2.8 , have you any additional info to get it fixed.

Description:
------------
A DbUpdateException is thrown with "ORA-00932: inconsistent datatypes: expected - got CLOB"
when saving a (xml) string into an Oracle XMLType column (here: "EIS_XEXC.XEXC_DATA")
using the method System.Data.Entity.Internal.InternalContext.SaveChanges().

Infos:
-----
Tested XMLTypes failed:
- XMLType AS BINARY
- XMLType AS CLOB

Tested successfully:
--> The code works well with an Oracle CLOB column.

Regards,
Johannes

Re: ORA-00932: inconsistent datatypes: expected - got CLOB

Posted: Wed 19 Mar 2014 13:36
by Shalex
We have asked for an additional information by e-mail.