Zeos doesn't see the same records as PL/SQL
Posted: 22.04.2022, 09:05
Hello,
I have a strange situation here. I connect to the same database from the same TNSNames.ora descriptor with the same user, password and schema, using the same oci.dll with my application using Zeos and PL/SQL and execute the same query: SELECT ID FROM MyTable WHERE ID = xxx
Now, PL/SQL happily shows me the record, Zeos says there are no records to show. SELECT * FROM v$instance shows that both are indeed connected to the same instance. I already changed everything back to the default (no codepage, no transaction isolation) and the record still doesn't show up.
Now, this is a generic question, I do not suspect an issue in Zeos just yet. What can cause the two clients to see different data?
Any tips are appreciated.
I have a strange situation here. I connect to the same database from the same TNSNames.ora descriptor with the same user, password and schema, using the same oci.dll with my application using Zeos and PL/SQL and execute the same query: SELECT ID FROM MyTable WHERE ID = xxx
Now, PL/SQL happily shows me the record, Zeos says there are no records to show. SELECT * FROM v$instance shows that both are indeed connected to the same instance. I already changed everything back to the default (no codepage, no transaction isolation) and the record still doesn't show up.
Code: Select all
Connection information: Oracle 19.0.0, client version: 19.8.0, database access component version: 8.0.0-d1cbb3e2b
Connected to database xxx, schema xxx at host xxx:1521 as user xxx
Loaded library: C:\xxx\DRVOracle\oci.dll
Transaction isolation level: None
RawStringEncoding: DB_CP
OCIMultiThreaded: TrueAny tips are appreciated.
