Re: [Q] How can I prevent infinite loop?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 18 Sep 1999 09:50:29 +0800
Message-ID: <37E2EFE5.1ECB@yahoo.com>

¹Ú³ëö wrote:
>
> 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.

Take a look at profiles - you can set the maximum amount of resource that an account can use before its gets killed...

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Sep 17 1999 - 20:50:29 CDT