+- 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: Problems Retrieving Oracle Data (/showthread.php?tid=24810)
Problems Retrieving Oracle Data - El Forum - 11-20-2009
[eluser]fireproofsocks[/eluser]
Wow, the more I play with Oracle, the more I hate it. It's like the perfect database.... for a web site written in FORTRAN. I've had to reinvent the wheel on so many MySQL functions... such a waste of time.
Anyhow, my queries are now very very simple and they execute, but the results don't behave how I expect, and it has to do with how the table is structured and how the php driver works. Here's the barebones:
Code:
$str = "
SELECT *
FROM MY_TABLE
WHERE ROWNUM <= 1";
$query = $this->db->query($str);
return $query->result_array();Now, if I do a print_r($results), I see this weird OCI-Lob Object thing in there, which causes all kinds of errors:
Code:
Array
(
[SYNOPSIS] => OCI-Lob Object
(
[descriptor] => Resource id #43
)
[OTHER_COLUMN] => OtherValue
)What's going on? I don't want an OBJECT. I want the data that it's pointing to! How can I get it? Seems very similar to this http://www.oracle-base.com/forums/viewtopic.php?f=1&t=8925&p=17216 .