Update ODPI-C to support fetching XMLType as strings

anthony-tuininga · anthony-tuininga · commit 4c12b47573f7 · 2018-12-03T10:20:14.000-07:00
(oracle#14).
diff --git a/odpi b/odpi
@@ -1 +1 @@
-Subproject commit 61f68d7e3e4fc01559a5bb1ca7a1a06cef49339f
+Subproject commit d51e9c496381427dd09f7fb0cbaab3e152667026
diff --git a/test/Cursor.py b/test/Cursor.py
@@ -626,3 +626,16 @@ def testVarTypeWithObjectType(self):
         self.assertEqual(result,
                 "udt_Object(28, 'Bind obj out', null, null, null, null, null)")
 
+    def testFetchXMLType(self):
+        "test that fetching an XMLType returns a string contains its contents"
+        intVal = 5
+        label = "IntCol"
+        expectedResult = "<%s>%s</%s>" % (label, intVal, label)
+        self.cursor.execute("""
+                select XMLElement("%s", IntCol)
+                from TestStrings
+                where IntCol = :intVal""" % label,
+                intVal = intVal)
+        result, = self.cursor.fetchone()
+        self.assertEqual(result, expectedResult)
+
