这是我写的请指教

sillyboy (silly)
CREATE OR REPLACE TRIGGER UBLOB AFTER UPDATE OF V_RESPONSE ON USER_PROFILES
FOR EACH ROW
BEGIN
UPDATE USER_PROFILES SET CREATE_DATE=SYSDATE WHERE USER_NAME=:new.USER_NAME and JURISDICTION= :new.JURISDICTION and V_NAME= :new.V_NAME;
END

V_RESPONSE是一个BLOB COLUMN.
SQL/PLUS提示:ORA-25006: cannot specify this column in UPDATE OF clause

我改为:
CREATE OR REPLACE TRIGGER UBLOB AFTER UPDATE ON USER_PROFILES
FOR EACH ROW
BEGIN
UPDATE USER_PROFILES SET CREATE_DATE=SYSDATE WHERE USER_NAME=:new.USER_NAME and JURISDICTION= :new.JURISDICTION and V_NAME= :new.V_NAME;
END
通过. 不过不起作用.

谢谢
(#275864@0)
2001-11-26 -05:00

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

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

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