ExecutePageReader method, ORA-00918: column ambiguously defined

[Tachiro]

Hi, I have a SQL that the user passed to me.

Code: Select all

select a.*, b.* from tblwiplotbasis a, tblwiplotbasis b

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

[Shalex]

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

[Shalex]

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.

[Tachiro]

Thank you very much!