[Q] How can I prevent infinite loop?

Hello. I'm developing 3-tier WebApp using Oracle 8.0.4 on NT

By the way, I send Oracle certain SELECT statement, sometimes it doesn't response. In this situation, how can I distinguish whether it is retreiving data from table(there's so many data to dig) or fell into infinite loop?

In case of infinite loop, is it possible to abort the process and retuen error message to MTS Component or something that throws the SQL statement, by setting SQL_TIMEOUT or something like that?

Thanks in advance. Received on Fri Sep 17 1999 - 21:05:33 CDT