Database Error w/o error number in the DB_driver.php

[eluser]Unknown[/eluser]
This is brilliant - and it fixed my Oracle / CI problem. Thanks!

[quote author="Lehbyos" date="1342713329"][quote author="ndsadona" date="1323218468"]
(snip)

Please, look at the SQL query generated by CI:

Code:

SELECT * FROM "project_users" WHERE "userid" = 'user1' AND "password" = 'iamuser1'

Note that the table names and table fields has double quotes, and that the reason of the issue: in a oracle SQL query, you DONT escape the name of the identifiers.

Looking in the source of CI, de base class CI_DB has a flag indicating that identifiers MUST be escaped. This is not necessary in Oracle, so i just add this attribute in system/database/drivers/oci8_diver.php...

Code:

var $_protect_identifiers = FALSE;

(If someone else want to test it, I put the line above before the method db_connect() on the OCI 8 Driver).

(snip)

Regards[/quote]