How can I see the full query used by a Data Block's execute_query?
I have to app servers and their corresponding databases. "In theory" these environments are identical (staging/testing and production). My problem is that in the testing side I am getting query errors that fortunately do not occur in production.
Error: FRM 40505 ORACLE error: unable to perform
query. ORA-00942: table or view does not exist.
In my mind this is a misleading message and not the true problem. Any help is appreciated.