cannot change NEW values for this column type in trigger
来源:互联网 发布:淘宝粉丝抢红包 编辑:程序博客网 时间:2024/05/25 08:13
ORA-25003: cannot change NEW values for this column type in trigger
Cause: Attempt to change NEW trigger variables of datatype object, REF, nested table, VARRAY or LOB datatype which is not supported.
Action: Do not change the NEW trigger variables in the trigger body.
放在BEFORE中即可,不要用AFTER:
CREATE OR REPLACE TRIGGER t_temp1
BEFORE INSERT OR UPDATE ON temp1
FOR EACH ROW
DECLARE
BEGIN
IF(:NEW.v1 = '0') THEN
:NEW.v2 := '0';
ELSE
:NEW.v2 := '1';
END IF;
END t_temp1;
Cause: Attempt to change NEW trigger variables of datatype object, REF, nested table, VARRAY or LOB datatype which is not supported.
Action: Do not change the NEW trigger variables in the trigger body.
放在BEFORE中即可,不要用AFTER:
CREATE OR REPLACE TRIGGER t_temp1
BEFORE INSERT OR UPDATE ON temp1
FOR EACH ROW
DECLARE
BEGIN
IF(:NEW.v1 = '0') THEN
:NEW.v2 := '0';
ELSE
:NEW.v2 := '1';
END IF;
END t_temp1;
- cannot change NEW values for this column type in trigger
- Change Column in MySQL
- "Cannot resolve collation conflict for column 1 in SELECT statement."
- 05 trigger the checkbox column in datagridview
- Oracle APEX 报错List of Values not supported for this type
- DML statment cannot operate on trigger.new or trigger.old
- cannot change DocValues type from SORTED_SET to NUMERIC for field "readTimes"
- cannot change DocValues type from SORTED_SET to NUMERIC for field xxx
- cannot change DocValues type from SORTED_SET to NUMERIC for field xxx
- This is a built-in profile,change the name to create a new profile(MyEclipse)
- ORA-04092: cannot COMMIT in a trigger
- Cannot switch on a value of type String for source level below 1.7. Only convertible int values or e
- Cannot insert explicit value for identity column in table 'settings' when IDENTITY_INSERT is set to OFF.
- Cannot insert explicit value for identity column in table 'settings' when IDENTITY_INSERT is set to OFF.
- Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
- Cannot insert explicit value for identity column in table 'TableNa' when IDENTITY_INSERT is set to O
- 解决SQL 的Cannot resolve collation conflict for column 6 in SELECT statement.报错
- OCP_052_51 automate this configuration for the memory components with change in mode of working
- JAVA的简单数据类型和复合数据类型
- 【欧拉计划2】Even Fibonacci numbers
- vim替换命令2
- MVC3 表达式树不能包含动态操作
- 黑马学习笔记——operator?:
- cannot change NEW values for this column type in trigger
- csapp2e 家庭作业 2.90
- 启用Oracle口令的安全特性
- Android异步处理系列文章索引
- AIDA64 v2.85.2400
- Windows下删除Oracle
- 苹果为什么不直接与谷歌打官司
- 给老外索要仿真代码信件
- sqlserver分页的几种写法