create or replace trigger test_trigger
before insert or update or delete on aa
for each row
begin
insert into aa_log select audsid from v$session;
end; 错误提示如下:Compilation errors for TRIGGER EZF.TEST_TRIGGER Error: PLS-00201: identifier 'SYS.V_$SESSION' must be declaredLine: 5Text: insert into aaa select audsid from v$session; Error: PL/SQL: SQL Statement ignoredLine: 5Text: insert into aaa select audsid from v$session; 但是单独执行这个语句insert into aa_log select audsid from v$session一点问题都没有 请问这是什么原因
before insert or update or delete on aa
for each row
begin
insert into aa_log select audsid from v$session;
end; 错误提示如下:Compilation errors for TRIGGER EZF.TEST_TRIGGER Error: PLS-00201: identifier 'SYS.V_$SESSION' must be declaredLine: 5Text: insert into aaa select audsid from v$session; Error: PL/SQL: SQL Statement ignoredLine: 5Text: insert into aaa select audsid from v$session; 但是单独执行这个语句insert into aa_log select audsid from v$session一点问题都没有 请问这是什么原因
解决方案 »
- 一个SQL问题
- 怎样把xml导入到oracle!
- oracle导出数据库出现的错误
- sql如何统计学生成绩
- oracle9i里面过程和函数的区别是什么?
- 求救触发器?急??????//
- 各位达人,请教php连接oracle8i使用连接池技术的资料和例子!!叩首!
- 如何将动态pl/sql中的执行特权授给调用者
- 怎么备份数据库?
- 启动OracleOraHome81ManagementServer服务错误
- form6i和developer2000支持oracle8,oracle8i,oracle9i吗?
- Help!我用VC访问oracle,能从数据库中读出数据,但写入时出错了,m_pRecordset->AddNew();的时候出错了,大家帮帮忙!
CONNECT / AS SYSDBA;
GRANT SELECT ANY TABLE TO EZF;
COMMIT;
connect / as sysdba;
grant select on sys.v_$session to ezf;
commit;