create or replace trigger inport after insert on test1
begin
declare ent int := 453;qr varchar2(200) := '';
begin
qr := 'create table test'||cast(ent as varchar2)||'(id int, val varchar2(20), date_ex date)';
begin
execute immediate qr;
-- dbms_output.put_line('everyting is correct here');
end;
end;
end;
if i run trrigger without execute immediate the trigger work correctly but when i add the statement execute imediate i got a error