2 Replies Latest reply: Jun 19, 2008 7:22 PM by Madrid RSS

    Error when use create_record on multiple_block in Oracle Application

    624441
      I work with oracle application and i have a multiple block and i create a Loop to populate it. My problem is, when i use a command "create_record" the forms close.

      PROCEDURE P_TESTA IS
      v_cont number := 0;
      BEGIN
           go_block('B1');
           first_record;

      for i in 1..3 loop
           v_cont:= v_cont + 1;

      :b1.codigo_r3 := v_cont;

      if :system.record_status!='NEW' then
           create_record;
           end if;     
      end loop;
      END;