CI with Oracle

[eluser]Unknown[/eluser]
I am unable to use the same DB object to run more than 1 query. I am using Oracle Database for back-end. I find myself having to create new connections ($db = $this->load->database()) every time I need to run another query. Has any body had this problem? Any idea why the SQL statement is being cached?

For example, I can't do this:

Code:

$this->load->database();
$this->db->query($query1)
....
$this->db->query($query2)

The second query returns the same data the first one does.

[eluser]steel_slasher[/eluser]
As far as i am aware oracle is not supported

on an unrelated subject oracle said they hire me today to work at their company

[eluser]Unknown[/eluser]
The easiest way I've found to fix this issue is to make the changes outlined in this post on my blog:

http://techxplorer.com/2008/11/03/using-...-database/

Essentially, as far as I can tell the issue is that the database library tries to re-use statement ids which doesn't work with Oracle.

As to Oracle not being supported, with the two changes outlined in the blog post it is working really well in my environment. The only other change I'd suggest is to comment out any of the options in the database.php file that you don't need. I think one, or more, of them is causing intermittent issues with my connections.

Hope this helps.