Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 11g l FOR UPDATE & User Defined Functions locking

 
Richard J Maher
Trusted Contributor

Oracle 11g l FOR UPDATE & User Defined Functions locking

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