[Mono-bugs] [Bug 71318][Wis] New - Oracle Client failed on fetched values

[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 dieter@fiebelkorn.net.

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

--- shadow/71318	2005-01-15 11:58:44.000000000 -0500
+++ shadow/71318.tmp.31995	2005-01-15 11:58:44.000000000 -0500
@@ -0,0 +1,46 @@
+Bug#: 71318
+Product: Mono: Class Libraries
+Version: 1.1
+OS: 
+OS Details: Mac OS X 10.3.7
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Wishlist
+Component: Sys.Data.SqlClient
+AssignedTo: rodrigo@novell.com                            
+ReportedBy: dieter@fiebelkorn.net               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Oracle Client failed on fetched values
+
+Using Oracle 9i (Dev. Release) and 10g (official final Release) with Mono 1.1.3:
+
+1. Taking example from "http://www.go-mono.com/oracle.html" (Only connect string changed!)
+
+2. Changing /Library/Frameworks/Mono.framework/Versions/1.1.3/etc/mono/config
+    <       <dllmap dll="oci" target="clntsh" />
+    ---
+    >       <dllmap dll="oci" target="libclntsh.dylib" />
+
+3. Setting "DYLD_LIBRARY_PATH" and loading a typical ORACLE-Environment ("oraenv")
+
+4. Compile and run "TestExample.cs"
+
+- Connecting OK
+- OracleDataReader OK
+- reader.Read OK, reads correct times of lines
+- string employeeName = (string) reader["mdid"]; FAILED!!!!!
+
+Unhandled Exception: System.InvalidCastException: Cannot cast from source type to destination 
+type.
+in <0x00120> Test:Main (string[])
+
+All readed values are System.Null differnt to the real values in database! The fetch called many 
+times the table has rows.
+    //        string employeeName = (string) reader["mdid"];
+    //        string job = (string) reader["mdname"];
+    //        Console.WriteLine ("Empl ID: {0}  Name: {1}", employeeName, job);
+               Console.WriteLine ("Out");