ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
 *Cause:  Operating system process private memory has been exhausted

oracle@me:~> ulimit -a
core file size        (blocks, -c) unlimited
data seg size         (kbytes, -d) unlimited
file size             (blocks, -f) unlimited
max locked memory     (kbytes, -l) unlimited
max memory size       (kbytes, -m) unlimited
open files                    (-n) 1024
pipe size          (512 bytes, -p) 8
stack size            (kbytes, -s) unlimited
cpu time             (seconds, -t) unlimited
max user processes            (-u) 16384
virtual memory        (kbytes, -v) unlimited

SELECT id
, name
, viewfunc.fGetLeadAndTestCountCampaign(id) LEADCOUNT , 
ROUND(DECODE(viewfunc.fGetLeadCountDeliveredNW(id),0,0,
viewfunc.fGetLeadCountResponse(id)/viewfunc.fGetLeadCountDeliveredNW(id)*100),2) RESPONSEPCT ,
 viewfunc.fGetLeadCountResponse(id) RESPONSECOUNT , 
ROUND(DECODE(viewfunc.fGetLeadCountDelivered(id),0,0,
viewfunc.fgetleadcountopened(id)/viewfunc.fGetLeadCountDelivered(id)*100),2) OPENED , 
ROUND(DECODE(viewfunc.fgetleadcountopened(id),0,0,
viewfunc.fGetLeadCountResponse(id)/viewfunc.fgetleadcountopened(id)*100),2) CTROR 
FROM CAMPAIGN WHERE id IN 
( SELECT * FROM ( 
SELECT a.id FROM DEMO.CAMPAIGN a LEFT OUTER JOIN DEMO.iv_survey e  ON a.id=e.campaign_id , 
DEMO.users b , 
DEMO.campaignstatus c , 
DEMO.campaigntype d 
WHERE a.client_id = b.client_id 
AND b.dbusername=USER AND a.campaignstatus_id=c.id 
AND a.campaigntype_id=d.id 
AND (viewfunc.fhascampaignright(a.id)=1
OR viewfunc.fhascampaignrightstat(a.id)=1)
AND a.launcheddate IS NOT NULL
AND c.internalname = 'LAUNCHED' 
AND a.archiveddate IS NULL
AND viewfunc.fcampaignvisible(a.campaignfolder_id)=1
ORDER BY a.launcheddate DESC )
WHERE ROWNUM < 6 )
ORDER BY syscreated DESC

Error message is

ORA-04030: out of process memory when trying to allocate 123404 bytes (QERGH hash-agg,kllcqas:kllsltba)

ORA-06512: at "DEMO.VIEWFUNC", line 1471
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: at "DEMO.VIEWFUNC", line 1478
ORA-06512: