DROP TABLE test PURGE;

CREATE TABLE test (id NUMBER);

DROP TABLE test1 PURGE;

CREATE TABLE test` (id NUMBER);

BEGIN
   INSERT INTO test
        VALUES (1);

   INSERT INTO test
        VALUES (2);

   INSERT INTO test
        VALUES (3);

   INSERT INTO test
        VALUES (4);

   INSERT INTO test
        VALUES (5);

   INSERT INTO test
        VALUES (6);

   INSERT INTO test
        VALUES (7);

   INSERT INTO test
        VALUES (8);

   COMMIT;
END;


BEGIN
   INSERT INTO test1
        VALUES (1);

   INSERT INTO test1
        VALUES (7);

   INSERT INTO test1
        VALUES (8);

   COMMIT;
END;

SELECT * FROM sad1;


DECLARE
   TYPE t1 IS TABLE OF test1.id%TYPE;

   a_id   t1;
   a      NUMBER;
BEGIN
   SELECT id
     BULK COLLECT INTO a_id
     FROM test
    WHERE id NOT IN (SELECT id
                       FROM test1
                      WHERE test.id = test1.id);

   FOR r IN 1 .. a_id.COUNT
   LOOP
        INSERT INTO test1 VALUES (a_id(r).id);

      a := SQL%ROWCOUNT;
      DBMS_OUTPUT.put_line (a);
   END LOOP;
END;

I am getting below  error.

ORA-06550: line 16, column 34:
PLS-00487: Invalid reference to variable 'TEST1.ID%TYPE'
ORA-06550: line 16, column 34:
PL/SQL: ORA-22806: not an object or REF
ORA-06550: line 16, column 9:
PL/SQL: SQL Statement ignored

SQL> DECLARE
  2  TYPE t1 IS TABLE OF test1.id%TYPE;
  3  
  4  a_id t1;
  5  a NUMBER;
  6  BEGIN
  7  SELECT id
  8  BULK COLLECT INTO a_id
  9  FROM test
 10  WHERE id NOT IN (SELECT id
 11  FROM test1
 12  WHERE test.id = test1.id);
 13  
 14  FOR r IN 1 .. a_id.COUNT
 15  LOOP
 16  INSERT INTO test1 VALUES (a_id(r).id);
 17  
 18  a := SQL%ROWCOUNT;
 19  DBMS_OUTPUT.put_line (a);
 20  END LOOP;
 21  END;
 22  /
INSERT INTO test1 VALUES (a_id(r).id);
                          *
ERROR at line 16:
ORA-06550: line 16, column 27:
PLS-00487: Invalid reference to variable 'TEST1.ID%TYPE'
ORA-06550: line 16, column 27:
PL/SQL: ORA-22806: not an object or REF
ORA-06550: line 16, column 1:
PL/SQL: SQL Statement ignored

SQL> DECLARE
  2  TYPE t1 IS TABLE OF test1.id%TYPE;
  3  
  4  a_id t1;
  5  a NUMBER;
  6  BEGIN
  7  SELECT id
  8  BULK COLLECT INTO a_id
  9  FROM test
 10  WHERE id NOT IN (SELECT id
 11  FROM test1
 12  WHERE test.id = test1.id);
 13  
 14  FOR r IN 1 .. a_id.COUNT
 15  LOOP
 16  INSERT INTO test1 VALUES (a_id(r));
 17  
 18  a := SQL%ROWCOUNT;
 19  DBMS_OUTPUT.put_line (a);
 20  END LOOP;
 21  END;
 22  /
1
1
1
1
1
1
1
1

PL/SQL procedure successfully completed.

SQL> rollback;

Rollback complete.

SQL> insert into test1 select id from test;

8 rows created.

SQL> DECLARE
  2  TYPE t1 IS TABLE OF test1.id%TYPE;
  3  
  4  a_id t1;
  5  a NUMBER;
  6  BEGIN
  7  SELECT id
  8  BULK COLLECT INTO a_id
  9  FROM test
 10  WHERE id NOT IN (SELECT id
 11  FROM test1
 12  WHERE test.id = test1.id);
 13  
 14  FORALL r IN 1 .. a_id.COUNT
 15  INSERT INTO test1 VALUES (a_id(r));
 16  a := a_id.COUNT;
 17  DBMS_OUTPUT.put_line (a);
 18  END;
 19  /
8

PL/SQL procedure successfully completed.

DECLARE
    v_id_list sys.OdciNumberList;
    v_cnt number;
BEGIN
   SELECT id
     BULK COLLECT INTO v_id_list
     FROM test
    WHERE id NOT IN (SELECT id
                       FROM test1
                      WHERE test.id = test1.id);
   INSERT INTO test1 SELECT * FROM TABLE(v_id_list);
   v_cnt := SQL%ROWCOUNT;
   DBMS_OUTPUT.put_line(v_cnt);
END;
/
5

PL/SQL procedure successfully completed.

SQL>

SQL> INSERT
  2    INTO test1
  3    SELECT  id
  4      FROM test
  5      WHERE id NOT IN (SELECT id
  6                         FROM test1
  7                        WHERE test.id = test1.id);

5 rows created.

SQL>