Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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`: https://pastebin.com/iyp3zQLe

repro CLI command:

Get-Content in.txt | .\sqlplus.exe system/atk4_pass@127.0.0.1:1521/free

repro output: https://pastebin.com/3B9kghaz

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: https://github.com/php/php-src/issues/12588 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
Comments
Post Details
Added on Nov 7 2023
5 comments
283 views