Oracle Forms (MOSC)

MOSC Banner

How can I see the full query used by a Data Block's execute_query?

edited Nov 13, 2014 10:02AM in Oracle Forms (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center