Skip to Main Content
Forums

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EF Core 3.1 beta - Pagination

user5943561Jul 6 2020 — edited Jul 7 2020

Hi all,

I tried the beta for EF Core with a paginated query (i.e using Skip and take in lambda)

The generated SQL looks like :

select ... from ... where ... OFFSET :p_1 ROWS FETCH NEXT :p_2 ROWS ONLY

However, my server answers : SQL Error [933] [42000]: ORA-00933

Is this because my server version is not supported ? I've seen that the EF core beta supports "11.2.0.4 and higher" but I do not think that the OFFSET .. FETCH NEXT has been introduced before 12c ...

Here are the details of my server version:

Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

"CORE 11.2.0.1.0 Production"

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production
This post has been answered by Alex Keh-Oracle on Jul 6 2020
Jump to Answer
Comments
Post Details
Added on Jul 6 2020
#odp-net
2 comments
663 views