I think you should define a default valuse as SYSDATE for the column CREATE_DATE. When the column is update and no value is assigned to the column CREATE_DATE,then its value is SYSDATE.
You can not use UPDATE OF clause when you create a trigger on LOB,BLOB columns.
You can not read the :NEW value when you create a trigger on LOB,BLOB columns, that's why your trigger never executed.
This post has been archived. It cannot be replied.