Oracle 21c

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

CREATE   TYPE o_A as OBJECT
        (
            A1 VARCHAR2 (4000)
      )
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 aa (query_result    t_A)
is
    v_i   INTEGER;
begin
    SELECT MAX (oA_id)
          INTO v_i
          FROM table_o_A;
          
    FORALL i IN INDICES OF query_result
            INSERT INTO table_o_A(
                            oA_id,
                            oA)
                 VALUES ( v_i+1, query_result (i));
                 --vi+1 instead of vi+i
end;
/
CREATE PROCEDURE a (query_result    t_A)
is
    v_i   INTEGER;
begin
    SELECT MAX (oA_id)
          INTO v_i
          FROM table_o_A;
          
    FORALL i IN INDICES OF query_result
            INSERT INTO table_o_A(
                            oA_id,
                            oA)
                 VALUES ( vi+i, query_result (i));
end;
/
ORA-24344: success with compilation error

select * from user_errors;


NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
ATTRIBUTE
MESSAGE_NUMBER


A
PROCEDURE
1
13
30
PLS-00430: FORALL iteration variable I is not allowed in this context
ERROR
430

A
PROCEDURE
2
13
27
PL/SQL: ORA-00984: column not allowed here
ERROR
0

A
PROCEDURE
3
10
13
PL/SQL: SQL Statement ignored
ERROR
0


drop procedure aa;
drop procedure a;
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;
/
select * from user_errors;
insert into table_o_A (oA) values (new o_A('A'));
1 rows affected

select t.oA_id, t.oA.A1 from table_o_A t;


OA_ID
OA.A1


1
A


begin
  a(t_A(o_A('B'), o_A('C')));
end;
/
1 rows affected

select t.oA_id, t.oA.A1 from table_o_A t;


OA_ID
OA.A1


1
A

2
B

3
C

NAME	TYPE	SEQUENCE	LINE	POSITION	TEXT	ATTRIBUTE	MESSAGE_NUMBER
A	PROCEDURE	1	13	30	PLS-00430: FORALL iteration variable I is not allowed in this context	ERROR	430
A	PROCEDURE	2	13	27	PL/SQL: ORA-00984: column not allowed here	ERROR	0
A	PROCEDURE	3	10	13	PL/SQL: SQL Statement ignored	ERROR	0