帮我看看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;
/