Anyone faced this error before..pls help!!
Database edition and version?
DB -Oracle 18.104.22.168.0
you should have a look at the web server log files. You mentioned that the query runs 1 min in Toad. I suspect that you are running into a web server timeout, where it aborts the request if it does not complete in a fixed amount of time. 1 minute is a very long time to display information in the browser.