17,377
社区成员
发帖
与我相关
我的任务
分享请问我的触发器什么错误？
我用system登陆，执行
create or replace trigger system.rt_aaa_insert
after insert on system.aaa
for each row
BEGIN
select * from sys.v$sql;
END;
出现错误
2/1 PL/SQL: SQL Statement ignored
2/39 PLS-00201: 必须说明标识符'SYS.V$SQL'
有人说是权限不够， 可system可以执行select * from sys.v$sql
why?
create or replace trigger system.rt_aaa_insert
after insert on system.aaa
for each row
BEGIN
select * from sys.v$sql;
END;
出现错误
2/1 PL/SQL: SQL Statement ignored
2/39 PLS-00201: 必须说明标识符'SYS.V$SQL'
有人说是权限不够， 可system可以执行select * from sys.v$sql
why?
...全文
请发表友善的回复…
发表回复
developer2002 2003-01-23
- 打赏
- 举报
sys用户下是v_$sql
yyy_5 2003-01-23
- 打赏
- 举报
改为：
create or replace trigger system.rt_aaa_insert
after insert on system.aaa
for each row
DECLARE
str_sqltext VARCHAR2(200);
BEGIN
select sql_text into str_sqltext from sys.v$sql
where first_load_time = '2000-1-1';
END;
同样错误
create or replace trigger system.rt_aaa_insert
after insert on system.aaa
for each row
DECLARE
str_sqltext VARCHAR2(200);
BEGIN
select sql_text into str_sqltext from sys.v$sql
where first_load_time = '2000-1-1';
END;
同样错误
jiezhi 2003-01-23
- 打赏
- 举报
select ... into ... from ...
