Re: How to exit from pl/sql

From: <>
Date: Wed, 30 Jan 2008 09:01:13 -0800 (PST)
Message-ID: <>

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

Original text of this message