Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: 'ora-03127' Err while Assigning DataSetProvider data to ClientDataSet data


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 0
karthik thirumo...

Posts: 23
Registered: 9/26/13
'ora-03127' Err while Assigning DataSetProvider data to ClientDataSet data  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 24, 2014 5:26 AM
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,

  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;
  


(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
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02