Getting 'ora-03127 no new operations allowed until the active operation ends' Error while executing  
  *cds.Data := TempProvider.Data;* line in DELPHI XE3, but the same is working in DELPHI 7.

  Below is my code,

  {code}
  procedure TExecCDS.DbExpCDSExec;
  var 
     TempProvider : TDataSetProvider;
  begin
    dbx.Close;
    dbx.SQL.Text := 'Select xmlagg((xmlelement (e, docid || ',')).extract (''//text()'')).getclobval() from localgrnhdr';
    Dbx.open;
    TempProvider := TDataSetProvider.Create(Owner);
    TempProvider.DataSet := dbx;
    cds.Data := TempProvider.Data;
    TempProvider.Free;
    TempProvider := nil;
  end;
  {code}
 
  (dbx:TSQLQuery , cds:TClientDataSet , TempProvider:TDataSetProvider)
  Note : i'm using oracle 11g.
  
  Please Give me a solution.

Edited by: karthik thirumoorthi on Sep 24, 2014 5:32 AM