ODP.NET oracleCommand.ExecuteReader() throws Exception ORA-00911
461225Oct 19 2005 — edited Oct 19 2005Hi,
I'm developing a simple application in VS.NET 2003 in C#, using the recent versions of Oracle 10g with the appropriate "Oracle Data Provider for .NET". After a successfull open of the connection I call a "SELECT TAGID FROM Visitor WHERE TAGID='HEF0402000146E237';" and get an Oracle.DataAccess.Client.OracleException ORA-00911 when no rows could be retrieved by issuing an ExecuteReader().
Same command works fine in sqlplus and also no exception is thrown if there is a row retrieved.
Any ideas?
Thanks in advance
Andreas Kesenheimer