I was given this view that when I query it using OracleSQLDeveloper it returns nothing, but if I use Toad it does return records!
I cannot inspect the definition of the view, and no errors are logged. The query is pretty simple:
select * from weirdview ;
So I have questions:
- It must be something different in the session/connection parameters, right?
- Is there a way to trace on server side what went wrong? I think there must be exceptions raised but ignored, would that be possible?
- How can I list the session parameters from the client that does see results so I can duplicate that configuration in the others.