Re: Procedure - how to lock some records in table
Date: Wed, 20 Aug 2008 01:45:47 -0700 (PDT)
SELECT ... FOR UPDATE OF ... NOWAIT with proper EXCEPTION (WHEN USER_DEFINED_ORA_00054 THEN result := 'rows locked'; - something like this) handle it well.
This action is moved to the subprocedure, and the conditions and result manageing is in the main procedure. Thanks for hints ;)
PiotreK Received on Wed Aug 20 2008 - 03:45:47 CDT