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: Auto generating Sequences !!

Re: Auto generating Sequences !!

From: chani <chanakam2000_at_gmail.com>
Date: 11 Apr 2006 23:17:51 -0700
Message-ID: <1144822671.073012.115190@u72g2000cwu.googlegroups.com>


>>>1) As it is written, it won't work

It worked without getting "table is mutating" error. But i got "table is mutating" error when i tried following code.

select count(loan_number)+1 into :new.payment_number from loan where

                           loan_number=:new.loan_number ;

It works without error when i first assign it to a variable and then to field.
(I posted my code after executing it and affter i got correct result).

That might be a feature of ORACLE 10g ex (or may be a bug !!)



But thank you verymuch for introducing me alternative solution(better than my solution)
And than for giving me the idea of row locking. I was not thinking about such thing before. Received on Wed Apr 12 2006 - 01:17:51 CDT

Original text of this message

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