Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_bb (
  fname VARCHAR2(255),
  lname VARCHAR2(255),
  idty VARCHAR2(255)
)
CREATE OR REPLACE PACKAGE MYPKG
AS
  TYPE emprec IS RECORD(
    fname TABLE_BB.FNAME%TYPE,
    lname TABLE_BB.LNAME%TYPE,
    idty  TABLE_BB.IDTY%TYPE
  );
  TYPE emprectype IS TABLE OF emprec INDEX BY BINARY_INTEGER;

  PROCEDURE proc_aaa (    
    p_emp      IN emprectype,
    x_status_code   OUT VARCHAR2,
    x_error_message OUT VARCHAR2
  );
END MYPKG;
/
CREATE OR REPLACE PACKAGE body MYPKG as
  PROCEDURE proc_aaa (    
    p_emp      IN emprectype,
    x_status_code   OUT VARCHAR2,
    x_error_message OUT VARCHAR2
  )
  IS
  BEGIN
    FORALL i IN 1 .. p_emp.COUNT
      insert into table_BB values (p_emp(i).fname,p_emp(i).lname,p_emp(i).idty);
  END proc_aaa;
END;
/
SELECT * FROM USER_ERRORS;
DECLARE
  v_emps MYPKG.EMPRECTYPE;
  v_status VARCHAR2(4000);
  v_error  VARCHAR2(4000);
BEGIN
  v_emps(1).FNAME := 'Alice';
  v_emps(1).LNAME := 'Abbot';
  v_emps(1).IDTY  := 'AAAAA';
  v_emps(2).FNAME := 'Beryl';
  v_emps(2).LNAME := 'Baron';
  v_emps(2).IDTY  := 'BBBBB';
  mypkg.proc_aaa(v_emps, v_status, v_error);
END;
/ 
1 rows affected

SELECT * FROM table_bb;


FNAME
LNAME
IDTY


Alice
Abbot
AAAAA

Beryl
Baron
BBBBB