07-06-2012, 01:36 PM
[eluser]Unknown[/eluser]
Hey all,
I am an employee at a university which loves it's Oracle databases, and I am a web / software developer who likes PHP and Codeigniter. When I tried to use the oci8 class present in CI 2.1.2, I ran into issue after issue.
Our particular situation uses Oracle Cursors and Stored Procedures extensively, and as of CI 2.1.2 the CI_DB_oci8_driver:
tored_procedure method resulted in utter failure.
To this end, I have gone through and modified how this driver functions, as well as CI_DB_Driver and CI_DB_oci8_result to accommodate the changes.
I have not done extensive testing on these, but I am now able to use the oci8 database driver class without issue, and I thought I'd share what I'd done.
I have created a GitHub repo to house these files as quite a bit has changed.
I'm also looking for any critiques / suggestions people have, would love to see what alternatives people suggest.
The files edited were:
/system/database/DB_Driver.php
/system/database/drivers/oci8/oci8_driver.php
/system/database/drivers/oci8/oci8_result.php
GitHub link:
ci_morebetteroracle
Again, questions / comments welcomed.
-Daniel
Hey all,
I am an employee at a university which loves it's Oracle databases, and I am a web / software developer who likes PHP and Codeigniter. When I tried to use the oci8 class present in CI 2.1.2, I ran into issue after issue.
Our particular situation uses Oracle Cursors and Stored Procedures extensively, and as of CI 2.1.2 the CI_DB_oci8_driver:
tored_procedure method resulted in utter failure.To this end, I have gone through and modified how this driver functions, as well as CI_DB_Driver and CI_DB_oci8_result to accommodate the changes.
I have not done extensive testing on these, but I am now able to use the oci8 database driver class without issue, and I thought I'd share what I'd done.
I have created a GitHub repo to house these files as quite a bit has changed.
I'm also looking for any critiques / suggestions people have, would love to see what alternatives people suggest.
The files edited were:
/system/database/DB_Driver.php
/system/database/drivers/oci8/oci8_driver.php
/system/database/drivers/oci8/oci8_result.php
GitHub link:
ci_morebetteroracle
Again, questions / comments welcomed.
-Daniel
