[imp] Oracle and array keys

liamr@umich.edu liamr@umich.edu
Sun, 20 Jan 2002 12:17:13 -0500


> Try adding something like this to the Prefs/sql.php driver:
> 
>     $this->db->setOption('optimize', 'portability');
> 
> Add that after the call to DB::connect().

This seems to work w/ PHP 4.11 and the version of PEAR from CVS.

Liam

--- sql.php.orig        Sun Jan 20 12:14:13 2002
+++ sql.php     Sun Jan 20 12:12:51 2002
@@ -97,8 +97,11 @@ class Prefs_sql extends Prefs {
 
             /* Connect to the SQL server using the supplied parameters. */
             include_once 'DB.php';
             $this->db = &DB::connect($this->params, true);
+           if ( $this->params['phptype'] == 'oci8' ) {
+               $this->db->setOption('optimize', 'portability');
+           }
             if (DB::isError($this->db) || DB::isWarning($this->db)) {
                 Horde::fatal($this->db, __FILE__, __LINE__);
             }