Zeos doesn't see the same records as PL/SQL

[aehimself]

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.

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: True

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.

[marsupilami]

I assume, you run both tests from the same machine? Honestly the only thing, I can think of would be some very strange kind of row level security. Maybe "Oracle Label Security"?

[aehimself]

Maybe "Oracle Label Security"? ;)

We recently upgraded our Oracle installations to 19, so it fits...
The reasons I have doubts are:
1, According to Oracle's website, Label Security is based on users, and both tools used the same user to log on
2, 3-4 hours later the records showed up in the tool using Zeos

Seems to be my stigma. The more I use Oracle products the more I want to change them to something different... but it's not in my power to do so... :)

[marsupilami]

Hmmm - good questions. I am happy I don't have to deal with Oracle anymore. The last product that used to use Oracle is starting to fade out at our clients and I rarely had to do anything about it. I think they replaced it with MS SQL Server. Although one might wonder wether that rally is a better choice...

Anyway - I am glad it is solved