Welcome Guest, Not a member yet? Register   Sign In
Problems Retrieving Oracle Data
#1

[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/viewto...25&p=17216 .




Theme © iAndrew 2016 - Forum software by © MyBB