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
victorperez2911
Posts: 3
Joined: Wed 24 Oct 2018 22:21

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

Post by victorperez2911 » Wed 24 Oct 2018 22:44

Hi

I am using the Dotconnect Provider for Oracle to connect an Oracle 10g through EF Core.

When you perform an OData query by using $TOP, a query is executed against the database by using an alias with an invalid ($) character.

How to proceed?

Generated Query

SELECT t.InternalId, t.additional_information, t.commercial_condition_code, t.customer_alternative_code, t.customer_code, t.customer_code_type, t.customer_email, t.customer_order_code, t.distribution_center_code, t.id, t.indicator, t.industry_code, t.is_free_good_discount, t.order_code, t.order_payment_term, t.profit_share_margin, t.recalculates_discount, t.salesman_code, t.sends_either_value_or_discount, t.sends_only_discount, t.status, t.wholesaler_branch_code, t.wholesaler_code
FROM (
SELECT $it.InternalId, $it.additional_information, $it.commercial_condition_code, $it.customer_alternative_code, $it.customer_code, $it.customer_code_type, $it.customer_email, $it.customer_order_code, $it.distribution_center_code, $it.id, $it.indicator, $it.industry_code, $it.is_free_good_discount, $it.order_code, $it.order_payment_term, $it.profit_share_margin, $it.recalculates_discount, $it.salesman_code, $it.sends_either_value_or_discount, $it.sends_only_discount, $it.status, $it.wholesaler_branch_code, $it.wholesaler_code
FROM Orders $it
ORDER BY $it.InternalId
) t
WHERE ROWNUM <= :p__TypedProperty_0

Error

ORA-00911: caractere inválido
00911. 00000 - "invalid character"
*Cause: identifiers may not start with any ASCII character other than
letters and numbers. $#_ are also allowed after the first
character. Identifiers enclosed by doublequotes may contain
any character other than a doublequote. Alternative quotes
(q'#...#') cannot use spaces, tabs, or carriage returns as
delimiters. For all other contexts, consult the SQL Language
Reference Manual.


Victor Perez


Pinturiccio
Devart Team
Posts: 2279
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.

victorperez2911
Posts: 3
Joined: Wed 24 Oct 2018 22:21

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

Post by victorperez2911 » Mon 05 Nov 2018 19:47

I need a solution to this problem.

Shalex
Site Admin
Posts: 8375
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.

Post Reply