This discussion is archived
3 Replies Latest reply: Aug 22, 2013 6:27 AM by Abdul Wahid RSS

How to find exact query executed by reports with parameters

Abdul Wahid Pro
Currently Being Moderated

Hi,

I am running a report which errors out with below log messages.

 

REP-0004: Warning: Unable to open user preference file.

REP-0300: ORACLE error occurred.

REP-0069: Internal error

REP-57054: In-process job terminated:Terminated with error:

REP-300: ORACLE error occurred.

 

In toad, the query is not giving any error message.

I want to know what exact query is being executed by oracle report server.

How can I find exact query executed?

 

Abdul Wahid


Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points