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: Deferrable vs. Not-Deferrable Constraints

Re: Deferrable vs. Not-Deferrable Constraints

From: phil <phil.horder_at_REMOVETHISuk.thalesgroup.com>
Date: Wed, 5 Feb 2003 09:55:30 -0000
Message-ID: <b1qn2m$s1n$1@rdel.co.uk> 





If an application is doing some processing, e.g. using Pro*C, an immediate
constraint gives the app. a chance of handling specific errors, and marking
duff records, etc.  If everything was deferred the app would only be able to
return a general database error,


and then roll back the whole job.  Does this only apply to batch processing?
maybe.
Received on Wed Feb 05 2003 - 03:55:30 CST












Original text of this message













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