Re: Procedure - how to lock some records in table

From: PiotreK <>
Date: Wed, 20 Aug 2008 01:45:47 -0700 (PDT)
Message-ID: <>

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

Original text of this message