.Net Core 5 ORA-00932 Error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
sdemir
Posts: 4
Joined: Tue 07 Jan 2020 06:41

.Net Core 5 ORA-00932 Error

Post by sdemir » Mon 15 Mar 2021 13:19

Hi,
I'm using HasColumnType for nclob data type but error,

Code: Select all

    modelBuilder.Entity<TodoProject>(b =>
            {
                b.Property(k => k.Name).HasMaxLength(GoConsts.OracleColumnMaxLength).HasColumnType("NCLOB");
            });
            

Devart.Data.Oracle.OracleException (0x80004005): ORA-00932: tutarsız veri türleri: olması gereken: - alınan: NCLOB

<TargetFramework>net5.0</TargetFramework>
<PackageReference Include="Devart.Data.Oracle.EFCore" Version="9.14.1204" />

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

Re: .Net Core 5 ORA-00932 Error

Post by Shalex » Wed 17 Mar 2021 14:13

It is not necessary to use .HasMaxLength() with the LOB columns.

Please send us a small test project with the corresponding DDL/DML script for reproducing the error.

Post Reply