Oracle Nextval issue

[eluser]Unknown[/eluser]
I was having the same problem -- calling something like:

Code:

$q = $this->db->query('SELECT somesequence.NEXTVAL FROM dual');
$result = $q->row();          // Increments three times
$result = $q->result();       // Increments three times
$result = $q->row_array();    // Increments two times
$result = $q->result_array(); // Increments two times

Looking deeper, I found that the function num_rows() in CI_DB_oci8_result (oci8_result.php) is calling ociexecute. This seems to be what's causing the extra DB queries that leads to the sequence getting incremented more than it should.

To remedy this, I altered the function to read as:

Code:

function num_rows()
{
    if ( $this->num_rows )      return $this->num_rows;
    if ( $this->result_array )  return count($this->result_array);
        
    return count($this->result_array());
    ...
}

In addition to that, I had to overwrite CI_DB_result's result_object() and row_object() functions for the oci8 driver.

This probably won't cover all the use cases, but it seems to be working for my application.