Re: How to exit from pl/sql
From: <wagen123_at_yahoo.com>
Date: Wed, 30 Jan 2008 09:01:13 -0800 (PST)
Message-ID: <6234322c-d6f5-469f-96f5-0522d6e3f8e8@k2g2000hse.googlegroups.com>
Date: Wed, 30 Jan 2008 09:01:13 -0800 (PST)
Message-ID: <6234322c-d6f5-469f-96f5-0522d6e3f8e8@k2g2000hse.googlegroups.com>
Thanks David for responding.
500 is just a test number. What we are trying to do:
- we have a table that has a high amount of DML all the time (24x7) in fact every second
- at midnight we want to truncate the table. the reason for the pl/sql procedure is to get around the ORA-00054 resource busy error.
Your suggestion for select count(*) may not work in this scenario. Received on Wed Jan 30 2008 - 11:01:13 CST