Don't use trigger in this situation.

laotang (laotang)
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.
2001-11-26 -04:00
This post has been archived. It cannot be replied.
Page address has been copied. To share, click to copy page address.
Share Online by QR Code

Back To Topic: 各位ORACLE高手帮忙,小弟要写一个简单的TRIGGER。谢谢!

Back To Forum: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论