[Mono-bugs] [Bug 72407][Wis] New - System.Data.OracleClient.OracleException

[bugzilla-daemon@bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by msyber@gmail.com.

http://bugzilla.ximian.com/show_bug.cgi?id=72407

--- shadow/72407	2005-02-09 11:32:38.000000000 -0500
+++ shadow/72407.tmp.27249	2005-02-09 11:32:38.000000000 -0500
@@ -0,0 +1,104 @@
+Bug#: 72407
+Product: Mono: Runtime
+Version: 1.0
+OS: 
+OS Details: windows XP
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Wishlist
+Component: misc
+AssignedTo: mono-bugs@ximian.com                            
+ReportedBy: msyber@gmail.com               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: System.Data.OracleClient.OracleException
+
+Description of Problem:
+
+After execution of my exe file have an exception error about oracle client.
+
+
+Steps to reproduce the problem:
+1. Source Pragram :
+using System;
+ using System.Data;
+ using System.Data.OracleClient;
+ 
+ public class Test 
+ {
+    public static void Main (string[] args)
+    {
+       string connectionString = 
+          "Data Source=mybase;" +
+          "User ID=mylogin;" +
+          "Password=mypassword;";
+       OracleConnection dbcon = null;
+       dbcon = new OracleConnection (connectionString);
+       dbcon.Open ();
+       OracleCommand dbcmd = dbcon.CreateCommand ();
+       string sql = "SELECT * FROM patient";
+       dbcmd.CommandText = sql;
+       OracleDataReader reader = dbcmd.ExecuteReader ();
+       while (reader.Read ()) {
+          string employeeName = (string) reader["nom"];
+          string job = (string) reader["prenom"];
+          Console.WriteLine ("Nom : {0}  Prénom: {1}",
+		                    employeeName, job);
+       }
+       // clean up
+       reader.Close ();
+       reader = null;
+       dbcmd.CommandText = sql;
+       dbcmd.ExecuteNonQuery ();
+       dbcmd.Dispose ();
+       dbcmd = null;
+       dbcon.Close ();
+       dbcon = null;
+    }
+ }
+
+
+2. Compilation OK :
+C:\Mono113\bin>mcs.bat oracle.cs /r:System.Data.dll
+/r:System.Data.OracleClient.dll
+
+
+3. Execute :
+C:\Mono113\bin>mono.bat HelloWindows.exe
+
+
+Actual Results:
+
+Result and this :
+Unhandled Exception: System.Data.OracleClient.OracleException:
+in <0x001af> System.Data.OracleClient.Oci.OciStatementHandle:Execute
+(bool,bool)
+
+in <0x00015>
+System.Data.OracleClient.Oci.OciStatementHandle:ExecuteNonQuery (bo
+ol)
+in <0x0004e> System.Data.OracleClient.OracleCommand:ExecuteNonQueryInternal
+(Sys
+tem.Data.OracleClient.Oci.OciStatementHandle,bool)
+in <0x00058> (wrapper remoting-invoke-with-check)
+System.Data.OracleClient.Oracl
+eCommand:ExecuteNonQueryInternal
+(System.Data.OracleClient.Oci.OciStatementHandl
+e,bool)
+in <0x0008c> System.Data.OracleClient.OracleCommand:ExecuteNonQuery ()
+in <0x0003f> (wrapper remoting-invoke-with-check)
+System.Data.OracleClient.Oracl
+eCommand:ExecuteNonQuery ()
+in <0x0014b> Test:Main (string[])
+
+
+Expected Results:
+No error.
+oracle.exe directly work correctly.
+
+Additional Information:
+
+Same result with 1.0.5