Forall limit
- From: "cichomitiko gmail" <cichomitiko@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 May 2005 18:08:11 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
