https://community.hpe.com/t5/operating-system-openvms/oracle-11g-l-for-update-amp-user-defined-functions-locking/m-p/4615172#M39759 Hi,<BR /><BR />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?<BR /><BR />Regards Richard Maher Sat, 10 Apr 2010 00:15:53 GMT Richard J Maher 2010-04-10T00:15:53Z https://community.hpe.com/t5/operating-system-openvms/oracle-11g-l-for-update-amp-user-defined-functions-locking/m-p/4615172#M39759 Hi,<BR /><BR />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?<BR /><BR />Regards Richard Maher Sat, 10 Apr 2010 00:15:53 GMT https://community.hpe.com/t5/operating-system-openvms/oracle-11g-l-for-update-amp-user-defined-functions-locking/m-p/4615172#M39759 Richard J Maher 2010-04-10T00:15:53Z