title: Codeigniter Oracle and CI_SESSIONS
body: <p>So I have had to make a few modifications to get Oracle to work with CI_SESSIONS. First I had to update the table in the config to be all uppercase. Second I extended the Session library class and overrode the create_session method so that it used all uppercase row names. </p>
  
  <p>However, on insert im still getting an error. The weird thing about it is that when I run the sql in the error in pl/sql developer it works fine. row inserts without a problem. </p>
  
  <p>Here is the sql:</p>
  
  <pre><code>INSERT INTO "CI_SESSIONS" ("SESSION_ID", "IP_ADDRESS", "USER_AGENT", "LAST_ACTIVITY", "USER_DATA") VALUES ('9df2c8be0e378bbfdc82a2808c1b3994', '172.16.1.86', 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.154 Safari/537.36', 1395328370, '')
  </code></pre>
  
  <p>Im at a loss for what to do next because its WORKING on my side but still erroring on the front end. </p>
  
  <p>Full error:</p>
  
  <pre><code>A Database Error Occurred
  
  Error Number:
  
  INSERT INTO "CI_SESSIONS" ("SESSION_ID", "IP_ADDRESS", "USER_AGENT", "LAST_ACTIVITY", "USER_DATA") VALUES ('9df2c8be0e378bbfdc82a2808c1b3994', '172.16.1.86', 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.154 Safari/537.36', 1395328370, '')
  
  Filename: /home/bgarrison/public_html/libraries/MY_Session.php
  
  Line Number: 34
  </code></pre>
  
  <p>I am currently using Oracle 10g enterprise</p>