Devart Forums

Hi, I have a SQL that the user passed to me. I use the ExecutePageReader method to execute it

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

Thank you for your report. We will investigate the issue and notify you about the result.

The bug with throwing ORA-00918 by OracleCommand.ExecutePageReader(), when SQL query returns several columns with the same name in the case of multiple result sets/multiple tables or views/subqueries, in Oracle 12c or higher is fixed in v9.14.1160: viewtopic.php?f=1&t=44320.

Thank you very much!