SQL Language (MOSC)

MOSC Banner

how i solve mutation

edited Jan 22, 2014 4:13AM in SQL Language (MOSC) 5 commentsAnswered
i create this trigger but mutation error occurred,how i solve it ? 

 create or replace trigger po.roy_trg_seq
  after insert  on po.RCV_TRANSACTIONS
  for each row
declare
  -- local variables here
begin
  if :new.transaction_type = 'DELIVER' and :new.organization_id = 83 then
    update po.rcv_transactions
       set attribute1 = (select nvl(max(nvl(attribute1, 0)), 0) + 1
                           from po.rcv_transactions
                          where transaction_type = 'DELIVER'
                            and organization_id = 83)
     where TRANSACTION_ID = :new.TRANSACTION_ID;
   
  end if;
end roy_trg_seq;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center