| Viewing the last query which reports ran [message #476686] |
Fri, 24 September 2010 09:31  |
ahazin
Messages: 39
Registered: August 2010
|
Member |
|
|
hi guys, im just starting out on reports, I have my report all set up and it takes in parameters etc however it sometimes does some weird things and I was wondering if there is a way to perhaps put something in the after report trigger or something which I can do to allow me to check the query the was run by my report. Sometimes it brings back no rows when it should be bringing back something thus I would like to see the query it has executed.
Any help would be greatly appreciated.
|
|
|
|
|
|
|
|
| Re: Viewing the last query which reports ran [message #476815 is a reply to message #476804] |
Sun, 26 September 2010 08:20  |
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Well the link I posted above shows some ways of turning it on and off.
TOAD I believe has tools to do the same but it's been a long time since I've used it. See if it's got a session monitor.
You will need access to the DB servers to get the trace file.
Suggest you talk to your DBA.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
