1.6w+
社区成员
- 主页
- Oracle 基础和管理
- Oracle 高级技术
- Oracle 认证与考试
- 职位交流
- 问答
帮我看看TRIGGER哪里写错了？
CREATE OR REPLACE TRIGGER trg_dropdeny
before drop on database
begin
v_username varchar2(100);
select username into v_username from user_users;
if (lower(ora_dict_obj_name())='t1') and (v_username='tetra0')
then
raise_application_error(
num=>-20000,
msg=>'You can not delete table ' || ora_dict_obj_name() || ' ! ');
end if;
end;
/
before drop on database
begin
v_username varchar2(100);
select username into v_username from user_users;
if (lower(ora_dict_obj_name())='t1') and (v_username='tetra0')
then
raise_application_error(
num=>-20000,
msg=>'You can not delete table ' || ora_dict_obj_name() || ' ! ');
end if;
end;
/
...全文
请发表友善的回复…
发表回复
fengwei004 2005-03-29
CREATE OR REPLACE TRIGGER trg_dropdeny
before drop on database
DECLARE
CURSOR p_username is
selecet username from user_users;
v_username user_users.username%type;
begin
open p_username;
fetch p_username into v_username;
close p_username;
if(lower(ora_dict_obj_name())='tl') and (v_username='tetra0')
then
raise_application_error(
num=>-20000,
msg=>'You can not delete table ' || ora_dict_obj_name() || ' ! ');
end if;
end;
before drop on database
DECLARE
CURSOR p_username is
selecet username from user_users;
v_username user_users.username%type;
begin
open p_username;
fetch p_username into v_username;
close p_username;
if(lower(ora_dict_obj_name())='tl') and (v_username='tetra0')
then
raise_application_error(
num=>-20000,
msg=>'You can not delete table ' || ora_dict_obj_name() || ' ! ');
end if;
end;
space6212327 2005-03-29
报什么错啊？