触发器语句如下:
create or replace trigger count_trigger
before insert or update or delete
on count
begin
insert into count_log(
who,when)
values(
user,sysdate);
end;
报错:
Compilation errors for TRIGGER TEST.COUNT_TRIGGERError: PLS-00103: Encountered the symbol "WHEN" when expecting one of the following:
<an identifier> <a double-quoted delimited-identifier>
The symbol "<an identifier> was inserted before "WHEN" to continue.
Line: 7
Text: who,when)我单独测试了一次insert into count_log(who,when) values(user,sysdate); 是可以实现的~ 有人可以指点一下报错原因么 ?
create or replace trigger count_trigger
before insert or update or delete
on count
begin
insert into count_log(
who,when)
values(
user,sysdate);
end;
报错:
Compilation errors for TRIGGER TEST.COUNT_TRIGGERError: PLS-00103: Encountered the symbol "WHEN" when expecting one of the following:
<an identifier> <a double-quoted delimited-identifier>
The symbol "<an identifier> was inserted before "WHEN" to continue.
Line: 7
Text: who,when)我单独测试了一次insert into count_log(who,when) values(user,sysdate); 是可以实现的~ 有人可以指点一下报错原因么 ?
解决方案 »
- 数据库应配置日志功能,对用户登录进行记录
- 如何删除列级主键?
- 一个sql
- ORA-01653: unable to extend table CAT_TRAN_HISTORIES by 8497 in tablespace DAT
- Oracle 领域的前辈们,围观过来,一起拍砖
- 怎样查询某一个用户在某时间段在特定的客户端所执行的操作
- hql按月分组查询
- 如果知道Oracle的字符集?
- RedHat8.0 ext3文件系统支持的最大文件有限制吗,是多少?
- window7安装oracle11g
- 我用exp a/a file....导出数据库,还原导入的时候,必须把a这个用户删除吗?
- 有关ORACLE JOB 急啊!!急啊!!急
insert into count_log(
"who","when")
values(
user,sysdate);
when 是PLSql 的保留字,你的字段名也是 when,冲突了。