[eluser]sansanwawa[/eluser]
[quote author="memopages" date="1208038947"]Hi, I use Oracle 10g and I
HAD the same problem. To solve it, you only have to do this :
Quote:Another update you may want to make is to the _set_stmp_id function in oci8_driver.php
Quote:Code:
//if ( ! is_resource($this->stmt_id))
//{
$this->stmt_id = ociparse($this->conn_id, $this->_prep_query($sql));
//}
If I understand correctly, if you execute more than one query per client request, the same prepared statement will be use for each query.
Another note....the oci8 driver in CI doesn’t support true bind variables. I would hope that it would be available in the next release of CI. I currenly have to use ADODB instead of the $this->db object to make use of bind variables.
I think that Code Igniter is not compatible with Oracle 9,10 & 11g because there is a lot of errors...
Any way, CI Rocks![/quote]
Thx bro for your reply,
just info for CI and oracle,if u want to delete or update records use..
Code:
$this->db->simple_query($sql)
that simple_query method has OCI_COMMIT_ON_SUCCESS after each query.
Hand to hand.
thanks
Sandy
