On 2006-03-02, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > No. Here is the offending SP: > > CREATE OR REPLACE FUNCTION update_my_cache() RETURNS void AS ' > BEGIN > > TRUNCATE TABLE my_cache_table;
TRUNCATE is another command that takes an access exclusive lock. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings