ORA-00932: inconsistent datatypes: expected - got CLOB
Posted: Mon 17 Mar 2014 09:53
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
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