Query Results Differ

[ESK]

Hello. We have a query that returns results (as expected) in most PL/SQL Developer session. However, there is one person in the office, when he runs the exact same query it returns "No rows found".

He is using the same version of PL/SQL Developer as the rest of us (7.1.3.1381).

I assume it's a configuration problem. Has anyone encountered this?

 

[Marco Kalter]

If the query is the same, and the tables/views are the same, then I can only imagine that the difference is caused by differences in the NLS settings. They are controlled by the Oracle registry, so that might explain it.

To verify this, take 2 PC's, perform the following query, and compare the results:

select * from nls_session_parameters
order by parameter