OCI Driver |
|||
|---|---|---|---|
| Date: | 06/18/2007 | Severity: | Critical |
| Status: | Duplicate | Reporter: | pdizzle |
| Version: | 1.5.3 | ||
| Keywords: | Libraries, Database Class | ||
| Forum Thread: | http://codeigniter.com/forums/viewthread/52849/ | ||
Description
It seems that once you run a query on a page, any additional queries that are attempted to run actually re-execute the first query called. It seems that the variable $this->stmt_id is not cleared after query execution or a new one isn’t created.
The simple fix that I found was to change the method _set_stmt_id() from the following:
Code Sample
function _set_($sql)
{
if ( ! is_resource($this->stmt_id))
{
$this->stmt_id = ociparse($this->conn_id, $this->_prep_query($sql));
}
}
Probably Should Be:
function _set_($sql)
{
$this->stmt_id = ociparse($this->conn_id, $this->_prep_query($sql));
}
Expected Result
Actual Result
Comment on Bug Report
| Posted by: Derek Jones on 30 January 2008 11:30am | |
|
This bug report has been supplanted by #2985/ |
