Hello
I tried using SQL/CLI (ODBC) driver from oracle-instantclient-23.6.0.24.10-1.el8.x86_64.rpm on Red Had 8, connecting to a 19c database, and my application sometimes receives SQL_NO_DATA from SELECT statements, even though the data is there and running the query in SQL Developer returns non-empty results. ( I know SQL Developer does not show changes from a pending transaction, but my application does not delete this data… )
The issue does not happen with a simple test query, so it is not so easy to reproduce.
Using strace to show network data received over TNS, I can see the row data arrives in the application process, but the driver still returns SQL_NO_DATA to the application.
Has this issue happened to anyone else ? Is this a known problem or is there a workaround ?