query oracle 9i problem - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21) +--- Thread: query oracle 9i problem (/showthread.php?tid=6694) |
query oracle 9i problem - El Forum - 03-08-2008 [eluser]sansanwawa[/eluser] Hi! im new in CI and i have a little bit problem within my oracle 9i query... this is my model Code: class M_summary extends Model and this is my controller Code: class Summary extends Controller when i used an object getVolRealization(),the query is still just like getInfo(),i'd was try to debug my output data (print_r) and the data is still like getInfo() method... im desperate with this ...,is it an influence from persistent oracle 9i connection? could any one help me how to figure it out.... warmest regards Thanks query oracle 9i problem - El Forum - 04-12-2008 [eluser]Unknown[/eluser] 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 I think that Code Igniter is not compatible with Oracle 9,10 & 11g because there is a lot of errors... Any way, CI Rocks! query oracle 9i problem - El Forum - 04-13-2008 [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 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 |