CodeIgniter Forums
last_query does not work for me with Oracle - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forumdisplay.php?fid=6)
+--- Forum: CodeIgniter 3.x (https://forum.codeigniter.com/forumdisplay.php?fid=17)
+--- Thread: last_query does not work for me with Oracle (/showthread.php?tid=64340)



last_query does not work for me with Oracle - SDir - 02-10-2016

How can I print the last query using CodeIgniter 3 and Oracle?


With same code, but with MySql, I write 


PHP Code:
print_r($this->db->last_query()); 


and I get successfully the print of the last query...


But if I move to Oracle db, It doesn't works for me...  no query are printed.

PS: I have grant on oracle V$SQL view.

Thank you


RE: last_query does not work for me with Oracle - Narf - 02-10-2016

There's no reason why it shouldn't work, it doesn't depend on the database in use.


RE: last_query does not work for me with Oracle - SDir - 02-11-2016

(02-10-2016, 11:11 AM)Narf Wrote: There's no reason why it shouldn't work, it doesn't depend on the database in use.

Thank you for your answer. 

I'm trying to understand why it happens... maybe OCI8 configuration?


RE: last_query does not work for me with Oracle - Narf - 02-11-2016

No, again - it doesn't depend on the driver, in any way.

You could've disabled it by setting save_queries to FALSE though.