OS Solaris 8
We have a procedure that fails with the fallowing error:ORA-04030
: out of process memory when trying to allocate bytes (,)ORA-06512
: at "PKG_PP", line 822ORA-04030
: out of process memory when trying to allocate bytes (,)ORA-06500
: PL/SQL: storage errorORA-06512
: at line 4
The procedure is using only FORALL clauses, no BULK COLLECT.
It seems that the forall clause is causing the error. How can we limit the
input collection in this case?
FORALL e in 1..cont_tot
delete PUSH_LIST_DELIVERY where