Correct binding of LOB values.

anthony-tuininga · anthony-tuininga · commit d9cf469167a0 · 2018-02-16T16:20:50.000-07:00
diff --git a/src/cxoTransform.c b/src/cxoTransform.c
@@ -236,7 +236,11 @@ int cxoTransform_fromPython(cxoTransformNum transformNum, PyObject *pyValue,
         case CXO_TRANSFORM_NCLOB:
             if (Py_TYPE(pyValue) == &cxoPyTypeLob) {
                 lob = (cxoLob*) pyValue;
-                dbValue->asLOB = lob->handle;
+                if (var) {
+                    if (dpiVar_setFromLob(var->handle, arrayPos,
+                            lob->handle) < 0)
+                        return cxoError_raiseAndReturnInt();
+                } else dbValue->asLOB = lob->handle;
                 return 0;
             }
             if (transformNum == CXO_TRANSFORM_NCLOB)
diff --git a/test/LobVar.py b/test/LobVar.py
@@ -125,6 +125,15 @@ def __ValidateQuery(self, rows, lobType):
                 string = prevChar * 5 + char * 5
                 self.assertEqual(lob.read(offset, 10), string)
 
+    def testBindLobValue(self):
+        "test binding a LOB value directly"
+        self.cursor.execute("truncate table TestCLOBs")
+        self.cursor.execute("insert into TestCLOBs values (1, 'Short value')")
+        self.cursor.execute("select ClobCol from TestCLOBs")
+        lob, = self.cursor.fetchone()
+        self.cursor.execute("insert into TestCLOBs values (2, :value)",
+                value = lob)
+
     def testBLOBCursorDescription(self):
         "test cursor description is accurate for BLOBs"
         self.cursor.execute("select * from TestBLOBs")
