I am using bulk collect with save exceptions, it runs fine sometimes and sometimes it errors out.

The error is as follows -

BEGIN
*
ERROR at line 1:
ORA-00028: your session has been killed
ORA-00028: your session has been killed
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-00001: unique constraint (<<Schema name>>.<<Target table COnstraint>>) violated
ORA-06512: at "<<Procedure name>.", line 181
ORA-06512: at line 2

My question is -

I still need to debug the PGA issue, I am using LIMIT 100 .. it gives the same error with LIMIT 1 also.

Why is it giving me a "ORA-00001: unique constraint (<<Schema name>>.<<Target table Constraint>>) violated" when I am using save exception.

If you want the code I can share the same but that may not be possible on an open site. Please help!!


Thanks!!

ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

select pga_used_mem, pga_alloc_mem , s.*
from   v$process p
join   v$session s
on     p.addr = s.paddr
order  by 1 desc;