Skip to Main Content

Oracle Database Free


For appeals, questions and feedback, please email

Unexpected empty result with Oracle Database v23/Free when NLS_COMP = 'LINGUISTIC' and bind params are used

user-n3svmNov 7 2023

I belive this is a bug in Oracle Database v23/Free as with Oracle Database v18 (or v21) and the same client there is no issue.

repro stdin file `in.txt`:

repro CLI command:

Get-Content in.txt | .\sqlplus.exe system/atk4_pass@

repro output:

reproduced using v23 database docker image/command:

docker run -it -p 1521:1521 -eORACLE_PASSWORD=atk4_pass gvenzl/oracle-free:23-slim-faststart

with v18/v21 the issue is not present:

docker run -it -p 1521:1521 -eORACLE_PASSWORD=atk4_pass gvenzl/oracle-xe:18-slim-faststart

Initially reported as php-src bug: but the issue is not in the client and can be reliably reproduced using sqlplus console as well. Tested from both Linux and Windows.

This post has been answered by Chris Saxon-Oracle on Apr 11 2024
Jump to Answer
Post Details
Added on Nov 7 2023