触发器不能编译- Oracle技术专区- 播布客. - Powered by Discuz!企业库|免费b2b网站

触发器不能编译- Oracle技术专区- 播布客. - Powered by Discuz!

Rank:

create or replace trigger grant_auto_trigger
after insert on ddl_log
for each row
declare
owner ddl_log.obj_owner%TYPE;
obj_type ddl_log.obj_type%TYPE;
obj_name ddl_log.object_name%TYPE;
sys_date ddl_log.attempt_dt%TYPE;
CURSOR PRIINFO IS SELECT obj_owner,obj_type,object_name,attempt_dt from ddl_log where obj_type='TABLE';
begin
open PRIINFO;
loop
fetch priinfo into owner,obj_type,obj_name,sys_date;
EXIT WHEN PRIINFO%NOTFOUND;
grant all on obj_name to SGPMS;
insert into grant_info values(owner,obj_type,obj_name,sys_date);
end loop;
close PRIINFO;
truncate table ddl_log;
end grant_auto_trigger;

复制代码

刚开始学习触发器.
大家帮我看看这个触发器有什么问题吗,编译的时候老是报错.
老郁闷了.

郑重声明：资讯【触发器不能编译- Oracle技术专区- 播布客. - Powered by Discuz!】由发布，版权归原作者及其所在单位，其原创性以及文中陈述文字和内容未经(企业库qiyeku.com)证实，请读者仅作参考，并请自行核实相关内容。若本文有侵犯到您的版权，请你提供相关证明及申请并与我们联系（qiyeku # qq.com）或【在线投诉】，我们审核后将会尽快处理。

—— 相关资讯 ——