Oracle 动态FORALL中作为绑定变量的PL SQL类型

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNS for Linux: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
复制

CREATE OR REPLACE PROCEDURE sp_test
AS

   TYPE typ_abc IS TABLE OF abc%rowtype INDEX BY BINARY_INTEGER;
   v_typ_abc                   typ_abc;
BEGIN
   --Code
   
         FORALL i IN v_typ_abc.FIRST .. v_typ_abc.LAST  SAVE EXCEPTIONS
            EXECUTE IMMEDIATE 'INSERT INTO ' || p_table_owner || '.' || p_table_name || ' /*+ PARALLEL 1 */ PARTITION ( ' || p_partition_name || ' ) '
                                             || ' ( ' || v_column_names_list ||' ) VALUES :1' USING v_typ_abc(i);
                                             
   --Code                                            
END;
/
复制

create table t (
  x int
);

create or replace procedure p  as
  type tp is table of t%rowtype index by binary_integer;
  recs tp;
begin
  recs(1).x := 1;
  recs(2).x := 2;
  
  forall i in 1 .. recs.count 
    execute immediate 'insert into t values (:v)' using recs(i).x;
end p;
/

exec p();
select * from t;

X   
  1 
  2
复制

create or replace procedure p  as
  type tp is table of t%rowtype index by binary_integer;
  recs tp;
begin
  recs(1).x := 1;
  recs(2).x := 2;
  
  forall i in 1 .. recs.count 
    insert into t values recs(i);
end p;
/
sho err

exec p();
select * from t;

X   
  1 
  2 
  1 
  2 
复制