Changeset 1588:653aa89e62a8

Timestamp:

02/22/10 07:45:19 (5 months ago)

Author:

Howard Butler <hobu.inc@…>

Branch:

default

Message:

support NULLs in most Binds

File:

• apps/oci_wrapper.cpp (modified) (6 diffs)

apps/oci_wrapper.cpp

@@ -568 +568 @@
         (ub4) nNextBnd,
         (dvoid*) pnData,
-        (sb4) sizeof(int),
+        (sb4) (pnData != NULL) ? (sb4)sizeof(int) : 0,
         (ub2) SQLT_INT,
         (void*) NULL,
@@ -585 +585 @@
     nNextCol++;
     
-    sb4 s = -1;
-    
-    if (pnData != NULL) 
-        s = (sb4)sizeof(long);
-    
-    printf("Setting size to %d\n", s);
     CheckError( OCIDefineByPos( hStmt,
         &hDefine,
@@ -596 +590 @@
         (ub4) nNextCol,
         (dvoid*) pnData,
-        (sb4) s,
+        (sb4) sizeof(long int),
         (ub2) SQLT_LNG,
         (void*) NULL,
@@ -610 +604 @@
     nNextBnd++;
     
-    printf("Binding long column #: %d\n", nNextBnd);
-
-    sb4 s = 0;
-    
-    if (pnData != NULL) 
-        s = (sb4)sizeof(long int);
-    
-    printf("Setting size to %d\n", s);
     CheckError( OCIBindByPos(
         hStmt,
@@ -624 +610 @@
         (ub4) nNextBnd,
         (dvoid*) pnData,
-        (sb4) s,
+        (sb4) (pnData != NULL) ? (sb4)sizeof(long int) : 0,
         (ub2) SQLT_INT,
         (void*) NULL,
@@ -646 +632 @@
         (ub4) nNextBnd,
         (dvoid*) pnData,
-        (sb4) sizeof(double),
+        (sb4) (pnData != NULL) ? (sb4)sizeof(double) : 0,
         (ub2) SQLT_BDOUBLE,
         (void*) NULL,