Welcome Guest, Not a member yet? Register   Sign In
Error Oracle + Session in DB
#1

[eluser]Unknown[/eluser]
I have a problem when using Session-PHP-Codeigniter + Oracle, as the sql generated by the Session has quotes in the names of columns and tables, but the Oracle does not accept. How to fix it?

SQL output ERRO:
SELECT * FROM pgj.sessions WHERE "session_id" = '5fa1216e9da0d8b50012acb3239a372e' AND "user_agent" = 'Mozilla/5.0 (X11; U; Linux x86_64; pt-BR; rv:1.9.0'
#2

[eluser]narkaT[/eluser]
did you choose the right database driver?
#3

[eluser]Unknown[/eluser]
Yes, the database.php config file have

$db['oci8']['dbdriver'] = "oci8";

When you use the drive of the postgres right!

Is it any configuration of Oracle?
#4

[eluser]bakazero[/eluser]
maybe if you try to comment this code will help...

$item = preg_replace( '/(^'.$lbound. ')([\w\d\ -\_]+?)(\ s|\)|$)/iS' , '$1"$2"$3', $item);

at oci8_driver.php line 575




Theme © iAndrew 2016 - Forum software by © MyBB