'CREATE OR REPLACE TRIGGER trigger' || table_name ||
'AFTER INSERT OR DELETE OR UPDATE ON '|| table_name ||
'FOR EACH ROW
DECLARE
v_Value system_tableaudit.CONTENT%TYPE;
BEGIN
dbms_output.put_line(table_name);
END;';改成下面这样试试
'CREATE OR REPLACE TRIGGER trigger''' || table_name ||
'''AFTER INSERT OR DELETE OR UPDATE ON '''|| table_name ||
'''FOR EACH ROW
DECLARE
v_Value system_tableaudit.CONTENT%TYPE;
BEGIN
dbms_output.put_line('table_name');
END;'
'AFTER INSERT OR DELETE OR UPDATE ON '|| table_name ||
'FOR EACH ROW
DECLARE
v_Value system_tableaudit.CONTENT%TYPE;
BEGIN
dbms_output.put_line(table_name);
END;';改成下面这样试试
'CREATE OR REPLACE TRIGGER trigger''' || table_name ||
'''AFTER INSERT OR DELETE OR UPDATE ON '''|| table_name ||
'''FOR EACH ROW
DECLARE
v_Value system_tableaudit.CONTENT%TYPE;
BEGIN
dbms_output.put_line('table_name');
END;'
is
strSql varchar2(4000) := '';
begin
strSql := 'CREATE OR REPLACE TRIGGER trigger' || table_name ||
' AFTER INSERT OR DELETE OR UPDATE ON '|| table_name ||
' FOR EACH ROW
DECLARE
v_Value system_tableaudit.CONTENT%TYPE;
BEGIN
dbms_output.put_line('''||table_name||''');
END;';
execute immediate strSql;
end;
/
AFTER INSERT OR DELETE OR UPDATE ON '||table_name||
'FOR EACH ROW
DECLARE
v_Value system_tableaudit.CONTENT%TYPE;
BEGIN
dbms_output.put_line('||table_name||');
END';
--还要足够权限grant create any trigger to user_name;
END;';
而且要有创建触发器的权限!!!