Getting ORA-03127: no new operations allowed until the active operation ends Error while executing below Query,
select xmlagg ((xmlelement (e, docid || ',')).extract ('//text()')).getclobval() as grnno,
xmlagg ((xmlelement (e, docdt || ',')).extract ('//text()')).getclobval() as grndt,
sum (ld.grnqty) as grnqty, ld.rate, sum (ld.netamt) grncuramt,
sum (ld.netcost) as omramt, ld.podtlid
from localgrnhdr lg, localgrndtl ld
where lg.cancel = 'F' and lg.localgrnhdrid = ld.localgrnhdrid
group by ld.rate, ld.podtlid
order by podtlid
Please give me solution to solve this issue.
Message was edited by: 24e4e882-113c-4873-8407-317c5d58c1a6