Re: cvs: pear /MDB2/MDB2/Driver oci8.php

Justin Patrin wrote:

justinpatrin Mon Sep 25 23:30:04 2006 UTC

  Modified files:                  /pear/MDB2/MDB2/Driver	oci8.php   Log:

For a buffered result set we need to load the LOBs as we fetch them

@@ -1143,6 +1143,11 @@

             if ($this->offset > 0) {
                 array_pop($buffer);
             }
+            foreach (array_keys($buffer) as $key) {
+                if (is_a($buffer[$key], 'oci-lob')) {
+                    $buffer[$key] = $buffer[$key]->load();
+                }
+            }
             $this->buffer[$this->buffer_rownum] = $buffer;
         }

I have thought about this issue a bit. I think we should probably have a parameter in the convertResult() method that automatically calls load() on all LOBs so that we do not need this expensive foreach() loop. I will try to implement something in the next 1-2 days, but I just wanted to throw this idea out there for people to comment. regards, Lukas