Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Get the first non-locked record.

Re: Get the first non-locked record.

From: Dmitry E. Loginov <dmitry_loginov_at_mtu.ru>
Date: Wed, 21 Nov 2001 16:07:13 +0300
Message-ID: <9tgch0$ed0$1@gavrilo.mtu.ru> 







> Why are you checking  if C_LOCK%isopen? Isn't that extra. I thought

> that the EXCEPTION can only be raised when it is open.

Definitely it's a extra checking in this sample. Usually I'm using such
construction in all exception handlers for the PL/SQL blocks where are
cursors opened explicitly. ;)


> Brian

Received on Wed Nov 21 2001 - 07:07:13 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US