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

Open
#486 3 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug
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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.