[indo-oracle] DML Trigger (After Update on table)

[laurens_kaseger]

Dear all,

Mohon bantuan sharingnya, 

Bagaimana agar  :New.l_field_nm   dan   :Old.l_field_nm
dapat terbaca 'nilai'-nya.

Contoh Trigger:
CREATE OR REPLACE TRIGGER TG_Customer
  AFTER UPDATE ON Customer
  REFERENCING NEW AS New OLD AS Old
  FOR EACH ROW
DECLARE
  l_field_nm   Varchar2(10) ;

  Cursor Rec_Data IS
    SELECT column_name
      FROM table_A
     WHERE table_name = 'Customer' ;
 
BEGIN

  FOR Rec IN Rec_Data LOOP
      l_field_nm := Rec.column_name ;
 
      IF :New.l_field_nm <> :Old.l_field_nm Then
         ->  proc ins_data 
      END IF

  END LOOP ;

END ;


Thanks vm
Laurens

[Non-text portions of this message have been removed]