errors with save exceptions and forall
Hi,
I have a table that contains duplicates keys. I insert the data in this table in another table that already contains data.
I use FORALL with SAVE EXCEPTIONS.
I do not get any errors of duplicates keys with sql%bulk_exception.
Oracle version is 10.2.0.1
Is this a known bug in this version, and what version is it fixed?
begin
forall i in 1..VI_DOS_NUMID.count() save exceptions
insert into IMP_CPT
(
DOS_NUMID,
TCP_NUM,
ECP_NUM,
UNT_NUM,
PTF_NUM,
CPP_SOLDE,
CPP_DATE_LV,
CPP_DATE_MODIF,
CPP_CUMUL_CREDIT,
CPP_DATE_CREA
)
values
(
VI_DOS_NUMID(i),
I have a table that contains duplicates keys. I insert the data in this table in another table that already contains data.
I use FORALL with SAVE EXCEPTIONS.
I do not get any errors of duplicates keys with sql%bulk_exception.
Oracle version is 10.2.0.1
Is this a known bug in this version, and what version is it fixed?
begin
forall i in 1..VI_DOS_NUMID.count() save exceptions
insert into IMP_CPT
(
DOS_NUMID,
TCP_NUM,
ECP_NUM,
UNT_NUM,
PTF_NUM,
CPP_SOLDE,
CPP_DATE_LV,
CPP_DATE_MODIF,
CPP_CUMUL_CREDIT,
CPP_DATE_CREA
)
values
(
VI_DOS_NUMID(i),
0