EntityFrameworkCore - querying NCLOB — oracle-tech

    Forum Stats

  • 3,715,645 Users
  • 2,242,819 Discussions
  • 7,845,476 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

EntityFrameworkCore - querying NCLOB

4085346
4085346 Member Posts: 4
edited October 2019 in ODP.NET

Hello, I've seen this documentation about annotating a string property with [MaxLength(65536)] to create an NCLOB column:

https://docs.oracle.com/en/database/oracle/oracle-data-access-components/19.3/odpnt/EFCoreLargeCharacter.html#GUID-AE805…

However, the issue I have is that I cannot query on this property. Comparing to the Devart driver, I can see that that uses a special compare function when it knows the property is mapped to an nclob column. However, with your Oracle driver, even with that annotation, the query does a straight string comparison, which is not allowed and leads to the error "ORA-00932: inconsistent datatypes: expected - got NCLOB"

Is this expected behaviour, or is this a known bug, and is there a way to fix it?

Thanks

Answers

Sign In or Register to comment.