Inconsistent DataType on XMLTYPE column

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Simonare
Posts: 5
Joined: Thu 18 Jan 2018 18:15

Inconsistent DataType on XMLTYPE column

Post by Simonare » Tue 09 Oct 2018 08:00

I am using .Net Core 2.1 with Devart.Data.Oracle 9.6.597.

I Have following Entity and Configuration

Code: Select all

  public class GuaranteeLetter : BaseEntity{
          public string XmlData { get; set; }  
  }

Code: Select all

     modelBuilder.Property<string>(x => x.XmlData).HasColumnType("XMLTYPE").ValueGeneratedNever();
On Oracle I have:

CREATE TABLE GUARANTEE_LETTER
(
XMLDATA XMLTYPE;
);

I have XMLTYPE column in database. When I try to insert data using Entity Framework Core 2.1 I am getting the error below.
ORA-00932: inconsistent datatypes: expected - got NCLOB
I Could not find solution or workaround for this issue.

I need urgent help.

Thanks

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

Re: Inconsistent DataType on XMLTYPE column

Post by Shalex » Thu 11 Oct 2018 19:51

Thank you for your report. We have reproduced the issue and will notify you when it is fixed.

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

Re: Inconsistent DataType on XMLTYPE column

Post by Shalex » Thu 25 Oct 2018 16:49

The bug with inserting data into XMLTYPE column via EF Core is fixed: viewtopic.php?f=1&t=37913.

Post Reply