1
Answer

Cannot allocate memory

Photo of Ramco Ramco

Ramco Ramco
23h
62
1

Hi

 

when i write below statement in query then i get error - cannot allocate enough memory. When i comment it works fine

WHEN T1."TransType" = '1470000049' THEN (

SELECT STRING_AGG(A0."Location", ', ')

FROM OITM A0 WHERE A0."ItemCode" IN (SELECT distinct("ItemCode") FROM ACQ1 WHERE "DocEntry" = T1."CreatedBy" AND "ObjType" = '1470000049'))

Thanks

Answers (1)

Next Recommended Forum