Page 1 of 1
"SQL statement doesn't return row" error
Posted: Mon 17 Jan 2005 08:01
by 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
Posted: Mon 17 Jan 2005 12:11
by Bagieta
You must have Oracle 9.x (server and client) to use 'with' statement
I use 9.2 both server and client version
Posted: Mon 17 Jan 2005 12:32
by 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.
Posted: Mon 17 Jan 2005 14:21
by Alex
"With" feature with Net options fixed in ODAC since version 5.10.
Please try ODAC 5.10 available for download from our site.