Oraloader.LoadFromDataSet Exception
Posted: Tue 23 Sep 2014 16:41
Delphi XE and XE6, ODAC 9.2.7 vs. 9.4.11, OCI 10.2.0.5.0
Hello,
since ODAC 9.3.8 Oraloader.LoadFromDataSet raise a Exception "Invalid row number"
when (OraTable.UniDirectional = TRUE) AND (OraTable.RecNo > OraTable.FetchRows)
The following code shows the cause:
Oraloader.LoadFromDataSet requires continuous Record Numbers.
SmartFetch mode does not work with the loader and large tables also.
Can you fix this bug please quickly.
best regards
Hello,
since ODAC 9.3.8 Oraloader.LoadFromDataSet raise a Exception "Invalid row number"
when (OraTable.UniDirectional = TRUE) AND (OraTable.RecNo > OraTable.FetchRows)
The following code shows the cause:
Code: Select all
procedure TForm2.Button1Click(Sender: TObject);
var i : Integer;
begin
OraTable1.UniDirectional := True; //Table Recordcount > 4000000 !!!
OraTable1.FetchRows := 100;
OraTable1.Options.QueryRecCount := True;
OraTable1.Open;
lbRecCount.Caption := IntToStr(OraTable1.RecordCount);
lbRecNo.Caption := IntToStr(OraTable1.RecNo);
// Value = 1
for i := 1 to OraTable1.FetchRows do
begin
OraTable1.Next;
end;
lbRecNo.Caption := IntToStr(OraTable1.RecNo); //
// <= ODAC 9.2.7 Value = 101
// >= ODAC 9.3.8 Value = 1 !!!
end;
SmartFetch mode does not work with the loader and large tables also.
Can you fix this bug please quickly.
best regards