Catchable fatal error: Object of class OCI-Lob could not be converted to string

Asked Apr 24 '19 at 12:59

Active Apr 24 '19 at 13:12

Viewed 199 times

I have return some code, which returns clob data from database and here I'm trying to display it in front end and ended up in getting some error.

Below is my function which returns data

Function tabledetails() {

    $sql = "my_query";

    $std = oci_parse($conn, $sql) ;

    oci_execute($std) ;

    While(oci_fetch($std)) {

        $sdeQuery = oci_result($std, 'attribute_name') ;

    }

    return array($sdeQuery) ;

}

In front end

$tb = tabledetails() ;
echo $tb[0];

What I have missed in this. Thanks in advance

edited Apr 24 '19 at 13:12

treyBake

6,440
6
26
57

asked Apr 24 '19 at 12:59

Karthik Sanu

2

`var_dump($tb);` it's probably an object. – AbraCadaver Apr 24 '19 at 13:01
And FYI you're only getting one from the function even if there are multiple. – AbraCadaver Apr 24 '19 at 13:02
@AbraCadaver yes that function returning more than one value, just for understanding I'm returning only one value – Karthik Sanu Apr 24 '19 at 13:05
array(3) {[0]=>NULL [1] => object (OCI-Lob)#1 (1) {["descriptor "]=>resource(25) of type(oci8 descriptor)} [2]=>string(15) " Insert new rows"} This is the error I'm getting after adding var_dump($tb) ; – Karthik Sanu Apr 24 '19 at 13:08
I don't know oci functions but `echo $tb[2];` maybe – AbraCadaver Apr 24 '19 at 13:14
It's returning $tb[2] value. Issue is with $tb[0] and $tb[1] – Karthik Sanu Apr 24 '19 at 13:16
0 is NULL and 1 is an object with a resource property which can't be echoed. – AbraCadaver Apr 24 '19 at 13:24
@AbraCadaver is there any way to display it – Karthik Sanu Apr 24 '19 at 13:32
It's not database data. You need to explain what you want to do exactly. – AbraCadaver Apr 24 '19 at 13:35
We have one field which has 4k + character and I'm trying to display it in front end. – Karthik Sanu Apr 24 '19 at 13:38

Catchable fatal error: Object of class OCI-Lob could not be converted to string

0 Answers0