Code: Select all
select a.*, b.* from tblwiplotbasis a, tblwiplotbasis b
the first time, I will get the first 500 records.
OracleDataReader myReader = myCommand.ExecutePageReader(CommandBehavior.Default, 0, 500);
but the second time,
OracleDataReader myReader = myCommand.ExecutePageReader(CommandBehavior.Default, 500, 500);
I will get the error below
ORA-00918: column ambiguously defined
if my sql has only one table like this, ExecutePageReader method is executing normally
select a.* from tblwiplotbasis a
Could you tell me how to fix this issue?
(dotConnect for Oracle, Standard, 9.13.1127)
Best Regards,
Tachiro