[Mono-bugs] [Bug 59939][Nor] Changed - OracleConnection:Open throth unhandled exection on Mac OS X 10.3.4

[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=59939

--- shadow/59939	2004-06-16 12:19:19.000000000 -0400
+++ shadow/59939.tmp.10372	2004-06-16 13:35:12.000000000 -0400
@@ -1,13 +1,13 @@
 Bug#: 59939
 Product: Mono: Runtime
 Version: unspecified
 OS: Mac OS X 10.3
 OS Details: MacOS X 10.3.4
-Status: RESOLVED   
-Resolution: FIXED
+Status: REOPENED   
+Resolution: 
 Severity: Unknown
 Priority: Normal
 Component: misc
 AssignedTo: mono-bugs@ximian.com                            
 ReportedBy: dieter@fiebelkorn.net               
 QAContact: mono-bugs@ximian.com
@@ -3478,6 +3478,143 @@
  MDNAME                                             VARCHAR2(30)
 
 
 ------- Additional Comments From miguel@ximian.com  2004-06-16 12:19 -------
 You need the "oci" library from Oracle, sadly this seems to not be
 supported on MacOS
+
+------- Additional Comments From dieter@fiebelkorn.net  2004-06-16 13:35 -------
+Whats about "libclntsh.dylib"? I have an running an application preprocessed with Pro*C! It 
+used OCI, isn't it?
+
+AND
+- i can connect to ORACLE
+- i can execute an Statement
+- the rows resulted are correct on fetch
+- ONLY the value is not returned
+SEEMs to be an handling, NULL or conversion problem!
+
+----- this works on MacOSX/Oracle -----
+
+typedef struct dbiCursor_s {
+... ...
+        struct sqlda    isqlda,                         /* EXECUTE, OPEN USING &isqlda */
+                              osqlda;                         /* FETCH USING &osqlda */
+        struct cda_def  cda;
+}dbiCursor_t;
+
+dbiCursor_t     *dcp;
+
+        for (i = 0; i < count; i++) {
+                struct sqlvar_struct    *svp    = &dcp->osqlda.sqlvar[i];
+                dbiVarSetAddr (&dcp->obindp->list[i], &dcp->osqlda.sqlvar[i]);
+                odefin (&dcp->cda, i + 1, svp->sqldata, svp->sqllen, svp->sqltype,
+                                -1, svp->sqlind, NULLP, -1, -1, NULLP, NULLP);
+        }
+
+        ofetch (&dcp->cda);
+
+        for (i = 0; i < dcp->obindp->count; i++)
+                dbiVarConvertOutput (&dcp->obindp->list[i], &dcp->osqlda.sqlvar[i]);
+
+-----
+
+$ORACLE_HOME/lib contains:
+libagent9.a
+libagtsh.dylib
+libclient9.a
+libclntsh.dylib
+libclntsh.dylib.9.0
+libclntsh.so.9.0
+libcommon9.a
+libcommon9.dylib
+libcore9.a
+libctx9.a
+libctxc9.a
+libctxx9.so
+libdl.a
+libgeneric9.a
+libgeneric9.dylib
+libgslavl9.a
+libgslber_s9.a
+libgsldb9.a
+libgslec9.a
+libgslmt9.a
+libgslr9.a
+libgslsg9.a
+libgslssb9.a
+libgslssf9.a
+libgx9.a
+libheteroxa9.so
+libheteroxa9_g.so
+libisqlplus.a
+libldapclnt9.a
+libldapjclnt9.a
+libldapjclnt9.so
+libmm.a
+libn9.a
+libnavhoa.a
+libnavshr.so
+libnbeq9.a
+libncrypt9.a
+libnhost9.a
+libnid.a
+libnjni9.so
+libnk59.a
+libnl9.a
+libnldap9.a
+libnls9.a
+libnoname9.a
+libnro9.a
+libnsgr9.a
+libnsslb9.a
+libntcp9.a
+libntcps9.a
+libntns9.a
+libnus9.a
+libnvbaseshr.so
+libnzjs9.a
+libocci9.a
+libocijdbc9.a
+libocijdbc9.jnilib
+libocijdbc9.so
+libocijdbc9_g.so
+libodm9.a
+libodm9.so
+liboraawt.so
+liboraioser.so
+libordimt9.a
+libordsdo9.a
+libowm2.so
+libplc9.a
+libplp9.a
+libpls9.a
+libpoll.a
+libpsa9.a
+libserver9.a
+libsgsl_s9.a
+libskgxn9.a
+libskgxn9.so
+libskgxns.a
+libskgxns.so
+libskgxp9.a
+libskgxpd.a
+libskgxpt.a
+libskgxpu.a
+libslax9.a
+libsnls9.a
+libsql9.a
+libsqlplus.a
+libtrace9.a
+libtracefe9.a
+libtracepls9.a
+libtracept9.a
+libunls9.a
+libwtc9.a
+libwtcserver9.a
+libwwg9.a
+libxdb.so
+libxml9.a
+libxmlg9.a
+libxsd9.a
+libzx9.a
+