CodeIgniter Forums
CLOB in Oracle DataBase - Printable Version

+- 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: CLOB in Oracle DataBase (/showthread.php?tid=17512)



CLOB in Oracle DataBase - El Forum - 04-07-2009

[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


CLOB in Oracle DataBase - El Forum - 04-07-2009

[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


CLOB in Oracle DataBase - El Forum - 04-07-2009

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

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

thank you alot Fuzzy!!!


CLOB in Oracle DataBase - El Forum - 04-30-2012

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

Why?