Welcome Guest, Not a member yet? Register   Sign In
Working with Clobs
#1

[eluser]imorris[/eluser]
I'm having trouble pulling a clob back from an Oracle database. I'm not sure what I have to do to handle the clob ('W.DESCRIPTION' in this case).

Here's what is in my Model:

Code:
function get_last_ten_changes()
    {
        $this->db->select('A.ASSETNAME, W.DESCRIPTION');
        $this->db->from('WORKORDER W');
        $this->db->join('ASSET A', 'W.ASSETID = A.ID','inner');
            $this->db->where('W.CHANGEREQUEST', '1');
        $this->db->limit(10);
        $query = $this->db->get();
        return $query;
    }

Here is the error I'm getting:

Code:
A PHP Error was encountered
Severity: 4096

Message: Object of class OCI-Lob could not be converted to string

Filename: views/welcome_message.php

Line Number: 62


Any suggestions?


Messages In This Thread
Working with Clobs - by El Forum - 09-23-2010, 03:01 PM
Working with Clobs - by El Forum - 09-23-2010, 03:29 PM
Working with Clobs - by El Forum - 09-24-2010, 09:34 AM
Working with Clobs - by El Forum - 09-24-2010, 12:00 PM



Theme © iAndrew 2016 - Forum software by © MyBB