Forall limit

Hi all,
environment:
Oracle 8.1.7.4.0
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 822
ORA-04030: out of process memory when trying to allocate  bytes (,)
ORA-06500: PL/SQL: storage error
ORA-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
ID_MSG_LIST=t_ID_MSG_LIST(e);
           end if;

Regards
Dimitre

--
http://www.freelists.org/webpage/oracle-l