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: reset a sequence in a trigger

Re: reset a sequence in a trigger

From: <ak_tiredofspam_at_yahoo.com>
Date: 19 May 2005 07:23:45 -0700
Message-ID: <1116512625.120490.137440@f14g2000cwb.googlegroups.com> 





altering a sequence is a DDL statement. Oracle always precedes any DDL
with an implicit commit. And yes, commits do not belong in a trigger.



I'd try to move altering the sequence into a storee procedure with
AUTONOMOUS TRANSACTION. 


Untested.
Received on Thu May 19 2005 - 09:23:45 CDT












Original text of this message













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