Connecting to Oracle Database 10g XE

[eluser]Andrias Siwabessy[/eluser]
There are a lot of articles I've tried. But it still doesn't solve my problem connecting CodeIgniter to Oracle Database 10g XE.
Can anyone guide me sequentially, please... :down:

Here is my software specification:
OS : Linux Mint 10 (Ubuntu Maverick) x86
CI Version : 2.1.0
DB Version : Oracle 10g XE
LAMPP : 1.7.7


And here is the last error I received:

A PHP Error was encountered

Severity: Notice

Message: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed 'OCI_COMMIT_ON_SUCCESS'

Filename: database/DB.php

Line Number: 144

Thanks for advance!

[eluser]Andrias Siwabessy[/eluser]
This problem is solved!
with this article.

But now i'm facing a new problem.

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 261900 bytes) in /path/to/ci/system/database/drivers/oci8/oci8_result.php on line 57

that error message is keep showing up.
i've changed the php.ini
but still not working.

Any expert advice? :down:

[eluser]Narf[/eluser]
https://github.com/EllisLab/CodeIgniter/pull/868

[eluser]Andrias Siwabessy[/eluser]
[quote author="Narf" date="1333347650"]https://github.com/EllisLab/CodeIgniter/pull/868[/quote]

[SOLVED]

OMG!!! You did it!


I LOVE YOU MAN!!!

Maybe, you have to publish your modified framework as CodeIgniter 2.1.1 or something!

[eluser]Narf[/eluser]
Don't get over-excited.
It will be released in 3.0.

[eluser]Andrias Siwabessy[/eluser]
It's just fine when i run this code:

Code:

$x=$this->db->query("SELECT * FROM employees");

but i got error when i tried to run this code:

Code:

$x=$this->db->get("jobs");

this is the error:

A Database Error Occurred

Error Number:

SELECT * FROM "jobs"

Filename: /opt/lampp/htdocs/ta/controllers/welcome.php

Line Number: 109

how can i solve this problem?

thanks