×

Loading...

这是我写的请指教

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 -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技术讨论