3 Replies Latest reply: Aug 22, 2013 8:27 AM by Abdul Wahid RSS

    How to find exact query executed by reports with parameters

    Abdul Wahid

      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