create or replace
TRIGGER TR_CHANGESTATUSCASE
BEFORE INSERT OR UPDATE OF "ERStatus" ON "ExpenseReport"
FOR EACH ROW
BEGIN
:new.ERStatus:= UPPER(:new.ERStatus);
END;Error(7,1): PLS-00049: 错误的赋值变量 'NEW.ERSTATUS'
Error(7,23): PLS-00049: 错误的赋值变量 'NEW.ERSTATUS'
TRIGGER TR_CHANGESTATUSCASE
BEFORE INSERT OR UPDATE OF "ERStatus" ON "ExpenseReport"
FOR EACH ROW
BEGIN
:new.ERStatus:= UPPER(:new.ERStatus);
END;Error(7,1): PLS-00049: 错误的赋值变量 'NEW.ERSTATUS'
Error(7,23): PLS-00049: 错误的赋值变量 'NEW.ERSTATUS'
解决方案 »
- 我想用java调用oracle触发器进行插入数据改怎么弄
- oracle 数据库首选身份证明问题
- Oracle TO_DATE函数表示月份的中英文区别??
- ORA-01033 ORACLE initialization or shutdown in progress
- Oracle触发器帮忙看一下!!!
- 使用ORACLE9I的EXTERNAL TABLE功能,文本中有汉字,但是查询出来的是乱码,如何解决?
- 9.01升级到9.02或更高版本
- 客户端切换的问题
- 各位大侠帮帮忙 ,在dbz studio 中怎样建一个sequence 和表空间?
- 问一个关于exp,imp的问题
- 小机上oracle9i的数据导出后,imp导入win2003操作系统oracle9i会报错不知为什么???
- 求一条trigger怎么写~~
Error(7,14): PLS-00049: 错误的赋值变量 'NEW.ERSTATUS'
Error(7,34): PLS-00049: 错误的赋值变量 'NEW.ERSTATUS'
TRIGGER TR_CHANGESTATUSCASE
BEFORE INSERT OR UPDATE OF ename ON emp
FOR EACH ROW
BEGIN
:new.ename:= UPPER(:new.ename);
END; select * from emp;update emp set ename='test' where ename = 'SMITH';
create table ExpenseReport
(
ERNo NUMBER(16) not null,
ERDesc VARCHAR2(255) not null,
ERSubmitDate DATE default SYSDATE not null,
ERStatusDate DATE default SYSDATE not null,
ERStatus VARCHAR2(8) default 'PENDING' not null,
SubmitUserNo NUMBER(16) not null,
ApprUserNo NUMBER(16)
);-- Create/Recreate primary, unique and foreign key constraints
alter table ExpenseReport add constraint ExpenseReport_PK primary key (ERNO);
-- CREATE OR REPLACE TRIGGER
CREATE OR REPLACE TRIGGER TR_CHANGE_STATUSCAS_EUPPER
BEFORE INSERT OR UPDATE OF ERStatus ON ExpenseReport
FOR EACH ROW
BEGIN
:new.ERStatus := UPPER(:new.ERStatus);
END;
测试通过