Welcome Guest, Not a member yet? Register   Sign In
CLOB in Oracle DataBase
#1

[eluser]Unknown[/eluser]
I try get content of clob using it:

in principal.php:
$query = $sup->recuperarRelato("QZMRCHTK");
$relato = $obj->getRelato($query);

in sup.php:
function recuperarRelato ($codigo)
{
$relato = $this->db->get_where('CAD_RELATO_ORIG', array('COD_RELATO_ORIG' => $codigo));
return $relato->result();
}

in obj.php

$relato->set_descricao( $obj[0]->DSC_RELATO_ORIG );

and have this response in browse:

[_descricao:private] => OCI-Lob Object
(
[descriptor] => Resource id #41
)

i try alot changes for read this resource or convert to string and not have success!
Sorry for my bad english and help if you know! Thanks
#2

[eluser]TheFuzzy0ne[/eluser]
Welcome to the CodeIgniter forums!

I don't know if this will help you or not, but it's a very similar problem to what you're describing - http://ellislab.com/forums/viewthread/108172/#545496
#3

[eluser]Unknown[/eluser]
$size = $data->size();
$ret = $data->read($size);

its a two magic lines for me... =]

thank you alot Fuzzy!!!
#4

[eluser]konradinho[/eluser]
Code:
Fatal error: Call to a member function size() on a non-object

Why?




Theme © iAndrew 2016 - Forum software by © MyBB