Trigger UDX_PASSWORD_NULL_FIX

CREATE OR REPLACE TRIGGER UDX_PASSWORD_NULL_FIX
BEFORE UPDATE OF CFSTRING2 ON ABPGRPCUSTOMFIELDV
FOR EACH ROW
BEGIN

   IF :NEW.CFSTRING2 IS NULL THEN
      :NEW.CFSTRING2 := DBMS_RANDOM.STRING('x', 8);
   END IF;
END;