oracle / oracle/dotnet-db-samples
Title: ORA-00911 invalid character error when executing "SELECT 1 FROM DUA" with non-breaking space in Oracle.ManagedDataAccess.Core 23.26.300
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 434
- Forks
- 191
- Avg merge
- 1d 15h
- Merged PRs (30d)
- 1
Description
Issue Description
When executing a simple query "SELECT 1 FROM DUAL" using Oracle.ManagedDataAccess.Core version 23.26.300, an ORA-00911: invalid character error is thrown. The same query works correctly in version 23.4.0.
Important Note
The space character in the SQL statement is not a regular space (U+0020) but a non-breaking space (U+00A0 / C2 A0 in UTF-8).
Steps to Reproduce
Use Oracle.ManagedDataAccess.Core version 23.26.300
Execute the following SQL statement (note: the space between SELECT and 1 is a non-breaking space, not a regular space):
sql
SELECT 1 FROM dual
Observe the error: ORA-00911: invalid character
Expected Behavior
The query should execute successfully and return 1 as it does in version 23.4.0.
Actual Behavior
The query fails with ORA-00911: invalid character.
Environment
Oracle.ManagedDataAccess.Core version: 23.26.300 (fails) / 23.4.0 (works)
Oracle Database version: (please specify)
Target framework: .NET 10.0
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Begin by reproducing the query with Oracle.ManagedDataAccess.Core 23.26.300 and compare it with 23.4.0, preserving the non-breaking space between SELECT and 1. Confirm the Oracle Database version and target framework during testing. Done means the query executes successfully and returns 1 with the affected version, matching the expected behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, sql
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100