EFCore - Oracle 10G - Nested Query Alias $it - ORA-00911 - Invalid Character

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Pinturiccio
Devart Team
Posts: 2292
Joined: Wed 02 Nov 2011 09:44

Re: EFCore - Oracle 10G - Nested Query Alias $it - ORA-00911 - Invalid Character

Post by Pinturiccio » Fri 02 Nov 2018 13:25

Sorry for the late response. We are processing your request. We will post here about the results as soon as possible.

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

Re: EFCore - Oracle 10G - Nested Query Alias $it - ORA-00911 - Invalid Character

Post by Shalex » Thu 08 Nov 2018 19:54

Please check your EF provider settings: have you set config.Workarounds.DisableQuoting=true; ? If yes, change the value of this option to false. Notify us about the result.

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

Re: EFCore - Oracle 10G - Nested Query Alias $it - ORA-00911 - Invalid Character

Post by Shalex » Thu 29 Nov 2018 13:43

The bug with quoting the table alias, that includes an invalid character, in the SQL query generated by EF Core is fixed: viewtopic.php?f=1&t=38123.

Post Reply