Re: Procedure - how to lock some records in table

From: PiotreK <piotr.knapik_at_gmail.com>
Date: Wed, 20 Aug 2008 01:45:47 -0700 (PDT)
Message-ID: <19e9a0a6-5395-4e8e-bd6a-1f945b8addaa@t54g2000hsg.googlegroups.com>

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 ;)