Well,

Actually, i just pumping/copy data from the same FB databases to another
table and i execute this via stored procedure.
Reason using SP is, the data on server is about thousand record in every
pumping.

Is there any setting on the connection or ib_query ( we using IBO )

regards

> While not dssource.eof do begin
> try
> dstarget.insert;
> dstarget['somefield'] := dssource['somefield']
> dstarget.post;
> except
> dstarget.cancel;
> end;
> dssource.next;
> database.commit; //or commit every n records
> End;