PROCEDURE P_INSERT_RECORD IS
l_last_record number;
l_list_id number;

BEGIN
	   --- current_record : Specifies the number of the current record in Block's list of records.
     --execute_immediate('truncate table emp_tt');
     l_list_id:=(select emp_seq.nextval from dual);
     go_block('b_detail');
     first_record;
     last_record;
     l_last_record:=:system.cursor_record;
     for i in 1..l_last_record
       loop
       	   go_record(i);
       	   if cb_select='Y' then
       	     -- I am struck here.. how to insert?
       	   
       	 
       	  
     
     
END;

SQL> insert all
  2    into dept (deptno, dname)        values (50, 'IT')
  3    into emp (empno, ename, deptno)  values (12, 'Littlefoot', 50)
  4    into emp (empno, ename, deptno)  values (87, 'Bigfoot'   , 10)
  5  select * from dual;

3 rows created.

SQL>