我用的是10.1版本,在用下面的语句创建触发器后,编译有错
Create or Replace Trigger Trg_ErrLog
before insert on "T_ErrLog"
REFERENCING NEW AS NEW OLD AS OLD
for each row
begin
select s_ErrLogid.Nextval into :new.ErrLogID from DUAL;
end;
或
Create or Replace Trigger Trg_ErrLog
before insert on "T_ErrLog"
REFERENCING NEW AS NEW OLD AS OLD
for each row
begin
:new.ErrLog:=s_ErrLogid.Nextval;
end;
都有问题,但用下面的方式编译没有问题,但插入记录时报错
Create or Replace Trigger Trg_ErrLog
before insert on "T_ErrLog"
REFERENCING NEW AS NEW OLD AS OLD
for each row
begin
insert into "T_ErrLog" ("ErrLogID") values (s_ErrLogID.Nextval);
end;
Create or Replace Trigger Trg_ErrLog
before insert on "T_ErrLog"
REFERENCING NEW AS NEW OLD AS OLD
for each row
begin
select s_ErrLogid.Nextval into :new.ErrLogID from DUAL;
end;
或
Create or Replace Trigger Trg_ErrLog
before insert on "T_ErrLog"
REFERENCING NEW AS NEW OLD AS OLD
for each row
begin
:new.ErrLog:=s_ErrLogid.Nextval;
end;
都有问题,但用下面的方式编译没有问题,但插入记录时报错
Create or Replace Trigger Trg_ErrLog
before insert on "T_ErrLog"
REFERENCING NEW AS NEW OLD AS OLD
for each row
begin
insert into "T_ErrLog" ("ErrLogID") values (s_ErrLogID.Nextval);
end;
解决方案 »
- 请教一个sql语句编写,把第一个不为0的数字前的所有0删掉
- occi有没有不抛异常的方式?
- 请问自定义的Oracle函数,怎样调用才正确?
- oracle包,函数,过程,游标的使用
- 请问哪里有oricle的安装包下载?
- 如下过程在sql *plus里如何调用执行啊?谢谢!
- 数据库备份问题。谢谢
- 高分:为什么VB取不到Oracle全局临时表的数据?
- 这个语句在ORACLE中怎样实现?
- 请教:oracle 9i for aix 下如何使用OEM?
- 机器上已经安装SQL Sever2005,请问在机器上再安装Oracle9i或Oracle10会不会有冲突?
- ★★★★★【200分求解OCI的一些问题】★★★★
BEFORE INSERT ON T_GQ_TZ_SYD_MX FOR EACH ROW
--表T_GQ_TZ_SYD_MX的字段id实现自增
BEGIN
SELECT S_T_GQ_TZ_SYD_MX.NEXTVAL INTO :NEW.ID FROM DUAL;
END;我是这样写的,我不知道你的For Each row前的那REFERENCING NEW AS NEW OLD AS OLD是什么意思。