• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.