Devart Forums

ODAC 7.0.0.1 with delphi 2010 in direct mode.
I have table with 380000 records.

try
with aaa do
begin
Open;
while not eof do
begin
Inc(i);
next;
application.ProcessMessages;
end;
close;
end;

it only show 9675 records.
but in oci mode. it shows all records

Hello,

I couldn't reproduce the problem.
Please send me a script to create the table to alexp*devart*com.

-- Create table
create table IPLOC
(
ip1 VARCHAR2(16) not null,
ip2 VARCHAR2(16) not null,
loc VARCHAR2(500),
ipnum1 NUMBER(10),
ipnum2 NUMBER(10)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 30
next 1
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table IPLOC
add constraint IPLOCPK1 primary key (IP1, IP2)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 28M
next 1M
minextents 1
maxextents unlimited
);

Hello,


I created the table and filled it with data (380000 records), but after executing your code I got a correct result.
We had some other problem with the direct mode in the 7.00.0.1 version of ODAC that is already fixed. Maybe your problem also is fixed. Please tell me your email to send the fixed *.dcu files.

Thank you, my email: xalion at xasyu.cn

Hello

I sent the fix by E-mail.

I use your new file. but I can't compiler the application.
it shows error:
[DCC Fatal Error] Unit1.pas(7): F2047 Circular unit reference to 'Unit1'

Hello,

Please, try compile new empty project without any components, and a new project with the TOraSession component. If the error persists, please reinstall ODAC, replace the DCU file and try again.
If it doesn't help, please contact me.

still have error!

Hello,

Please tell when the error arises - in the project that contains only TOraSession or in the project that contains other components.

only one orasession.

Hello,

Please uninstall all ODAC components and all *.DCU, *.BPL, *.DCP ODAC files.
Unpack and install the original ODAC components without changing the source code.
Try to compile the project with TOraSession, and if the compilation is successful, replace the OraNet.DCU file and try to compi'le the project again.

I am sorry, I put the oranet.dcu in delphi XE.
please send me a oranet.dcu for delphi xe.
Thank you again.

Hello

I sent the fix for Delphi XE by E-mail.

I got it.
I will test it tomorrow.
Thank you.