Codeigniter Oracle get_insert_id() - "This feature is not available for the database you are using." Error
I got a job I would be migrating an application developed in PHP/MYSQL to PHP/ORACLE. The first relieve was that the application was developed in Codeigniter.
As if all the challenges of setting up the server was not enough, I ran into "This feature is not available for the database you are using." error when using the Active Record $this->db->get_insert_id() fuction.
Immediately I got the concern in the ORACLE driver that was shipped with Codeigniter because ORACLE does not support this feature so I have to create a little function to help solve it.
The function will either return the last ID of all records from the DB or search the records with a unique ID of the record sent.
This solved the challenge.
Best luck...
