1 Reply Latest reply on Sep 23, 2014 10:32 AM by Harmandeep Singh

    Getting ORA-03127: no new operations allowed until the active operation ends Error

    2756698
      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