如何在oracle中为记录类型编写循环

-- 创建记录类型
CREATE TYPE employee_type AS OBJECT (
  employee_id NUMBER,
  first_name VARCHAR2(50),
  last_name VARCHAR2(50)
);

-- 创建记录类型的表类型
CREATE TYPE employee_table_type AS TABLE OF employee_type;

-- 创建存储过程，使用循环处理记录类型
CREATE OR REPLACE PROCEDURE process_employees(p_employees IN employee_table_type) IS
BEGIN
  FOR i IN 1..p_employees.COUNT LOOP
    -- 访问记录类型的属性
    DBMS_OUTPUT.PUT_LINE('Employee ID: ' || p_employees(i).employee_id);
    DBMS_OUTPUT.PUT_LINE('First Name: ' || p_employees(i).first_name);
    DBMS_OUTPUT.PUT_LINE('Last Name: ' || p_employees(i).last_name);
    DBMS_OUTPUT.PUT_LINE('------------------------');
  END LOOP;
END;