Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE   TYPE o_A as OBJECT
        (
            x VARCHAR2 (2),
            y VARCHAR2 (2)
      )
CREATE OR REPLACE TYPE t_A IS TABLE OF o_A;
CREATE TABLE table_o_A
(
      oA_id                INTEGER GENERATED BY DEFAULT AS IDENTITY,
      oA                   o_A,
      PRIMARY KEY (oA_id)
    );
CREATE PROCEDURE a (query_result    t_A)
is
begin
    FORALL i IN INDICES OF query_result
            INSERT INTO table_o_A(oA)
                 VALUES (query_result (i));
end;
/
begin
  a(t_A(o_A('x1','y1'), o_A('x2','y2')));
end;
/
1 rows affected

select t.oA_id, t.oA.x, t.oA.y from table_o_A t;


OA_ID
OA.X
OA.Y


1
x1
y1

2
x2
y2