how do you use active record to query rowid from oracle?

how do you use active record to query rowid from oracle? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: how do you use active record to query rowid from oracle? (/showthread.php?tid=33864)

how do you use active record to query rowid from oracle? - El Forum - 09-10-2010

[eluser]kimo_gusatava[/eluser]
I tried useing

Code:
$this->db->select('rowid, *');

        $this->db->from('EMPLOYEES');

        $this->db->where('EMPLOYEE_ID', $id);

result:

Code:
A Database Error Occurred

Error Number:

SELECT "rowid", * FROM "EMPLOYEES" WHERE "EMPLOYEE_ID" = '100'

also tried

Code:
$this->db->select('ROWIDTOCHAR(rowid), *');

        $this->db->from('EMPLOYEES');

        $this->db->where('EMPLOYEE_ID', $id);

result:

Code:
A Database Error Occurred

Error Number:

SELECT ROWIDTOCHAR(rowid), * FROM "EMPLOYEES" WHERE "EMPLOYEE_ID" = '100'

any help on this?