ORA-00932: inconsistent datatypes: expected - got CLOB

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
dumian
Posts: 13
Joined: Sat 09 Jun 2012 19:10
Contact:

ORA-00932: inconsistent datatypes: expected - got CLOB

Post by dumian » 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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Wed 19 Mar 2014 13:36

We have asked for an additional information by e-mail.

Post Reply