ORA-06550: line 34, column 4:
PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
create table tmp_table1 as select col1, col2, col3, col4, col5, col6 from table1 where 1 = 2;
declare
cursor curOrders is
select
a.col1, a.col2, a.col3, a.col4, a.col5, a.col6
from
table1 a
join
table2 b
on a.col1 = b.col1 and a.col2 = b.col2;
type tbl_bulk is table of curOrders%rowtype;
varOrders tbl_bulk;
begin
open curOrders;
loop
fetch curOrders bulk collect into varOrders limit 500;
forall indx in 1 .. varOrders.count
insert into tmp_table1
(col1, col2, col3, col4, col5, col6)
values
(varOrders(indx).col1, varOrders(indx).col2, varOrders (indx).col3, varOrders(indx).col4, varOrders(indx).col5, varOrders(indx).col6);
exit when curOrders%notfound;
--exit when varClaims.count < 500; which is better?
end loop;
close curOrders;
commit;
end;
/
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE