Fire Trigger

[Sase10]

I have a trigger that inserts a new value into a field after a row is commited. Is there a way I could create an insert triggers that inserts that number generated by the trigger into another field on the same row eg:
tblX has fields ID, ProgessID, Service
When ID is populated by the trigger and assigned a value say 10, that value is also automatically assigned to ProgessID ie ProgressID = 10 as well

Thank you

[LKBrwn_DBA]

Try adding this to your trigger:

...
  :NEW.ProgessID:=:NEW.ID;
...

PS: It has to be a BEFORE...trigger.

[Sase10]

Thank you. It is a before trigger and the trigger body that assigns a value to PSID is
BEGIN
SELECT .nextval
INTO :new.PSID
FROM dual;
END;

So should I make it
BEGIN
SELECT SVDB.S_114_2_TBLPROGRESSNOTE.nextval
INTO :NEW.ProgressID:=NEW.ID
FROM dual;
END;

[Sase10]

I tried it and I got error message
Line # = 3 Column # = 23 Error Text = PL/SQL: ORA-01745: invalid host/bind variable name

[LKBrwn_DBA]

No, you need two statement like this:

BEGIN 
  SELECT SVDB.S_114_2_TBLPROGRESSNOTE.nextval
    INTO :NEW.ID
    FROM dual;
  :NEW.ProgressID:=:NEW.ID;
END;

[Sase10]

Thank you LKBrown worked perfectly. Thats a new method I have learnt today . Please keep up the good work