Oracle 11g l FOR UPDATE & User Defined Functions locking
From: Richard Maher <maher_rj_at_hotspamnotmail.com>
Date: Sat, 10 Apr 2010 09:22:15 +0800
Message-ID: <hpojng$qp7$1_at_news-01.bur.connect.com.au>
Hi,
Date: Sat, 10 Apr 2010 09:22:15 +0800
Message-ID: <hpojng$qp7$1_at_news-01.bur.connect.com.au>
Hi,
If I have an SELECT query that is ended FOR UPDATE OF; (specifying no specific tables) and I also invoke a User Defined Function (via column select expression, or WHERE predicate, or FGAC) will any and all select statements within that UDF also be instructed to lock the rows that they touch?
Regards Richard Maher Received on Fri Apr 09 2010 - 20:22:15 CDT