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

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent: Problem with Cursor for UPDATE

Re: Urgent: Problem with Cursor for UPDATE

From: John Darrah <jdarrah_at_veripost.net>
Date: Fri, 18 May 2001 18:26:21 +0000 (UTC)
Message-ID: <9BAAB192E5938F448EDF31E326507DD2095351@DENS600> 






This quirk is documented on Jonathan Lewis' website
http://www.jlcomp.demon.co.uk/  Basically, in 8.1.5 (I think) Oracle would
let you get away with having a commit during the fetch of a for update
cursor.  8.1.6 and beyond don't let you do this.  The way around this is to
fetch out the rowid instead of using FOR UPDATE.


-- 
Posted from [63.83.225.245] 
via Mailgate.ORG Server - http://www.Mailgate.ORG


Received on Fri May 18 2001 - 13:26:21 CDT












Original text of this message













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