Welcome Guest, Not a member yet? Register   Sign In
Unsupported Oracle features, some fixes
#1

[eluser]Unknown[/eluser]
Hi everyone,

this is my first post here and I´d like to share some code :-)
I was studying Codeigniter to user here in my job, testing something to oracle databases

Well, there are some problems with codeigniter classes to access oracle databases so I made some fixes and I´d like to share them for testing and to get some opinion!

The fixes:
- Escape characters didn´t work in Oracle 10, so I changed the '"' in the driver class to ''
- Method $this->db->field_data('table') now returns the table primary key (before, it was unsupported for oracle)
- Method $this->db->insert_id() now returns the table last primary key inserted (I think THIS needs a lot of testing, but it works!)

I attached a file to this post so you can download and update the files inside que system/database folder.

Theses fixes just work if you use the active_record while retrieving data from your db.

Thank you!




Theme © iAndrew 2016 - Forum software by © MyBB