create procedure get_tri(p_tri in varchar2)
as
str varhcar2(500);
begin
str:='create trigger '||p_tri||
'before insert on table_name
for each row
begin
.....;
end';
execute immediate str; --grant create any trigger to user;
end;
/
as
str varhcar2(500);
begin
str:='create trigger '||p_tri||
'before insert on table_name
for each row
begin
.....;
end';
execute immediate str; --grant create any trigger to user;
end;
/
as
v_sql string(1000);
begin
v_sql:='create or replace trigger '||v_name||' ....';
...
end test;