关于oracle中EXECUTE immediate事务

Question

存储过程如下：
create or replace procedure proctest(
                                参数1，
                                参数2,
                                ...)
is
声明...
begin
  INSERT INTO 表名
                (
                                字段1,
                                字段2，
                                ...
                                )
                VALUES (
                                参数1,
                                参数2,
                                ...
                           );
 
   if(length(p_ids)>0) then
     DBMS_OUTPUT.put_line(p_ids);
     idsStr:='UPDATE 表名 SET ...';
         DBMS_OUTPUT.put_line(idsStr);
     EXECUTE immediate idsStr;
   end if ;
end proctest;前面的insert操作和后面的EXECUTE immediate idsStr操作是否在同一事务内？

Answer 1

是的，存储过程正确执行insert才会被commit

Answer 2

insert 以后没有提交,还在同一个事务内