Hi Friends,
I am using BULK COLLECT and BULK UPDATE in a stored proc which is selecting 1.5 Million records and updating the same. When i run this stored proc i am getting the below error

ORA-04030: out of process memory when trying to allocate 283468
bytes (callheap,DARWIN).

I am runing oracle 8.1.7.4, solaris 2.8 and have PHYSICAL RAM of 22 GB.

I went to metalink and found some solutions like increase the ulimit UNIX RESOURCE to the process and reducing the SORT_AREA_SIZE.

I tried this but still its failing.

ulimit -a on my unix box is
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 119200 ----this was earlier 8KB
coredump(blocks) 0
nofiles(descriptors) 1024
memory(kbytes) unlimited

and sort_area_size for the session is set to 1 MB.

Can anyone of you suggest me a solution if you had encountered the same problem and fixed it.