[Mono-list] OracleClient in Mono 1.0.2 - ORA-24333: zero iteration count

[Daniel Morgan]

I get an exception when execute a SQL statement that is not a query nor =
is a
DML command.

"ALTER SESSION SET NLS_DATE_FORMAT =3D 'YYYY-MM-DD'"

I was just want to confirm if this is normal if this is a bug.  If it is =
a
bug, was it fixed in a newer version of mono?  If not, I will file a =
bug.


danmorg@danpc ~/monosvn/sqlsharpgtk/sqlsharpgtk
$ mcs test.cs /r:System.Data.dll /r:System.Data.OracleClient.dll
Compilation succeeded

danmorg@danpc ~/monosvn/sqlsharpgtk/sqlsharpgtk
$ mono test.exe

Unhandled Exception: System.Data.OracleClient.OracleException: =
ORA-24333:
zero i
teration count

in <0x001b6> System.Data.OracleClient.Oci.OciStatementHandle:Execute
(bool,bool)

in <0x00015> =
System.Data.OracleClient.Oci.OciStatementHandle:ExecuteQuery ()
in <0x000be> System.Data.OracleClient.OracleCommand:ExecuteReader
(System.Data.C
ommandBehavior)
in <0x00010> System.Data.OracleClient.OracleCommand:ExecuteReader ()
in <0x0004d> (wrapper remoting-invoke-with-check)
System.Data.OracleClient.Oracl
eCommand:ExecuteReader ()
in <0x00080> OracleTest:Main (string[])


using System;
using System.Data;
using System.Data.OracleClient;

public class OracleTest=20
{
	public static void Main (string[] args)=20
	{
		OracleConnection con =3D new OracleConnection();
		con.ConnectionString =3D "data source=3Dpalis;user
id=3Dscott;password=3Dtiger";
		con.Open ();
		OracleCommand cmd =3D con.CreateCommand ();
		cmd.CommandText =3D @"alter session set nls_date_format =3D
'YYYY-MM-DD HH24:MI:SS'";
		//cmd.CommandText =3D @"SELECT * FROM SCOTT.EMP";
		OracleDataReader reader =3D  cmd.ExecuteReader ();
		if (reader.FieldCount > 0)=20
		{
			while (reader.Read ())=20
			{
				string ename =3D reader["ENAME"].ToString ();
				Console.WriteLine("ename:" + ename);
			}
		}
		reader.Close ();
		con.Close ();
	}
}