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.
(#275912@0)
2001-11-26 -05:00

回到话题: 各位ORACLE高手帮忙,小弟要写一个简单的TRIGGER。谢谢!

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论

URL:   
http://www.rolia.net/zh/post.php?f=0&p=275912