I am trying to get CI 1.70 to talk to Oracle and I keep getting the following error

Has anyone ever been able to get Oracle working on CI? I read on a few forums that this error come up quite often. I tried connecting to a Orace 10g express DB, and Oracel 9 as well, both gives me error.

Any help is really appreciated!

bump!

I finally got it! Thanks to this post over at techxplorer.

Here is a cut & paste of the solution, I give all credits to techxplorer.com.

1. Edit the driver [1]

Open the system/database/drivers/oci8/oci8_driver.php file
Navigate to line 162 to the _set_stmt_id function
Remove the check to see if the stmt_id variable is set. With the check in place the driver will attempt to re-use an existing stmt_id and only your first SQL statement will work as you expect. For example:

//if ( ! is_resource($this->stmt_id))  
//{  
//    $this->stmt_id = ociparse($this->conn_id, $this->_prep_query($sql));  
//}  
$this->stmt_id = ociparse($this->conn_id, $this->_prep_query($sql)); 

1. Edit the driver [2]

Keep the system/database/drivers/oci8/oci8_driver.php file open
Navigate to line 375 to the escape_str function
Replace the call to the _remove_invisible_characters function with the code below

function escape_str($str)  
{  
    // Access the CI object  
    $CI =& get_instance();  
  
    //return $CI->_remove_invisible_characters($str);  
    return $CI->input->_remove_invisible_characters($str);  
  
} 

Still BUG with reference cursor call.

i got the same issue with this, please any help?

Jbeetle - 28 October 2009 11:37 AM

Still BUG with reference cursor call.

$cursor = $this->db->get_cursor();
        $this->db->stored_procedure("jile","get_roles" ,array
            (array
                ('name' => ':cRoles',
                 'value' => $cursor,
                 'type' => OCI_B_CURSOR,
                 'length' => -1)
                 )
             ); 

Any one got it resolved ?