Welcome Guest, Not a member yet? Register   Sign In
CI_SESSIONS and ORACLE
#7

[eluser]kgill[/eluser]
My guess is the quotes, "CI_SESSIONS" will throw a ORA-00942 - table or view does not exist error. Oracle will let you get away with quoting the column names (it's not necessary though) but it will throw a fit if you try to quote the table name.

For future reference, anytime you run into an error with your SQL like that, paste it into SQLPlus/Toad/whatever interface you use to run queries and run the query there. CI doesn't pass Oracle's error codes back to you so the easiest way to track stuff down is to run it directly unless you feel like hacking the driver.


Messages In This Thread
CI_SESSIONS and ORACLE - by El Forum - 09-22-2009, 12:15 PM
CI_SESSIONS and ORACLE - by El Forum - 09-22-2009, 01:52 PM
CI_SESSIONS and ORACLE - by El Forum - 09-22-2009, 01:55 PM
CI_SESSIONS and ORACLE - by El Forum - 09-22-2009, 02:00 PM
CI_SESSIONS and ORACLE - by El Forum - 09-22-2009, 10:18 PM
CI_SESSIONS and ORACLE - by El Forum - 09-22-2009, 11:54 PM
CI_SESSIONS and ORACLE - by El Forum - 09-23-2009, 12:52 PM
CI_SESSIONS and ORACLE - by El Forum - 10-23-2009, 07:25 PM
CI_SESSIONS and ORACLE - by El Forum - 10-23-2009, 07:41 PM
CI_SESSIONS and ORACLE - by El Forum - 10-23-2009, 08:10 PM
CI_SESSIONS and ORACLE - by El Forum - 10-23-2009, 08:59 PM
CI_SESSIONS and ORACLE - by El Forum - 10-23-2009, 10:56 PM



Theme © iAndrew 2016 - Forum software by © MyBB