"SQL statement doesn't return row" error

[Danilkak]

I use Delphi 5 with Odac 4.50.3.23. This error message appear when i open TOraQuery with following simple text:

Code: Select all

with a as 
(
 select '1' 
 from dual
)
select *
from a

[Bagieta]

You must have Oracle 9.x (server and client) to use 'with' statement

[Danilkak]

I think error occured inside library code, which define mentioned operator how non-select and this error message is not Oracle error message.
SQLPlus execute this query succefully.

[Alex]

"With" feature with Net options fixed in ODAC since version 5.10.
Please try ODAC 5.10 available for download from our site.