Welcome Guest, Not a member yet? Register   Sign In
Problem with CI Session class + Oracle DB driver
#1

[eluser]Rob Stefanussen[/eluser]
Hi all,

I've run into an issue with the CI session class when used with the Oracle DB driver. In my searching, I came across this thread which had some useful information in it: http://ellislab.com/forums/viewthread/129918/#656946

Whenever there's a sess_update(), the script blows with an error. This an example query:

Code:
UPDATE "ci_sessions" SET "last_activity" = 1257986513, "session_id" = '73e6752f63e7ede91722a36b66a54dda' WHERE session_id = 'ded5e6dd8cccf9d5602e46cf1baa668d'

I did some troubleshooting in Oracle's "Application Express" and discovered that the query works if the last "session_id" is wrapped in double-quotes like the one before it. I found it odd that CI's DB class is enclosing the first "session_id" in double-quotes, but not the last. Does anyone have any pointers? I wanted to try my luck here in hopes that there is someone who has more expertise before I go tearing the DB class apart.

Thanks!

Rob Stefanussen
#2

[eluser]Rob Stefanussen[/eluser]
bump




Theme © iAndrew 2016 - Forum software by © MyBB