HPE Community
Operating System - OpenVMS
1753543 Members
5618 Online
108795 Solutions
New Discussion

Oracle 11g l FOR UPDATE & User Defined Functions locking

 
Richard J Maher
Trusted Contributor

‎04-09-2010 05:15 PM

‎04-09-2010 05:15 PM

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
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.