Problem session ci on Oracle 10g

[eluser]Unknown[/eluser]
Hi all,

I'm in trouble with the session, when the login session is working fine but after entering a login page, then moving the controller session that was previously made can not be called on that page. whether there are certain tricks in the use of session on the Oracle database because when using mysql sessions are working properly..

please solution to solve this problem ..

Thank you.

[eluser]David BoreaNaz[/eluser]
i've encountered a problem similar to this one.
may i know the make-up/schema of your session table?

[eluser]sungsoo[/eluser]
I had the same problem. Today I managed to solve this problem.

Modify the file named 'system/database/DB_driver.php' as shown below:


$ svn diff -r534 DB_driver.php
Index: DB_driver.php
===================================================================
--- DB_driver.php (revision 534)
+++ DB_driver.php (working copy)
@@ -946,7 +946,7 @@
{
if ( ! $this->_has_operator($key))
{
- $key .= ' =';
+ $key = $this->_protect_identifiers($key).' =';
}

$val = ' '.$this->escape($val);



I hope this would help you!

Cheers!

Sungsoo Kim

[eluser]sungsoo[/eluser]
Also I have posted this information at http://bitbucket.org/ellislab/codeigniter/issue/207 to help CodeIgniter team.