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
通过. 不过不起作用.

谢谢