declare
i_bank_id
varchar2(10) := '15';
i_bank_name varchar2(100) := 'testyy';
i_flag varchar2(1) := '0';
i_oper_time date := sysdate;
begin
execute immediate 'insert into sys_bank values(:p1,:p2,:p3,:p4)'
using
i_bank_id, i_bank_name, i_flag, i_oper_time;
commit;
end;