如何使用嵌套表类型的参数调用Oracle过程

CREATE OR REPLACE TYPE person_type AS OBJECT (
  name VARCHAR2(100),
  age NUMBER
);

CREATE OR REPLACE TYPE person_table_type AS TABLE OF person_type;

CREATE OR REPLACE PROCEDURE process_persons (
  p_persons IN person_table_type
) AS
BEGIN
  -- 处理传入的嵌套表类型参数
  FOR i IN 1..p_persons.COUNT LOOP
    DBMS_OUTPUT.PUT_LINE('Name: ' || p_persons(i).name || ', Age: ' || p_persons(i).age);
  END LOOP;
END;

DECLARE
  l_persons person_table_type;
BEGIN
  -- 初始化嵌套表类型参数
  l_persons := person_table_type();
  l_persons.EXTEND;
  l_persons(1) := person_type('John', 30);
  l_persons.EXTEND;
  l_persons(2) := person_type('Jane', 25);

  -- 调用过程并传递嵌套表类型参数
  process_persons(l_persons);
END;