[SOLVED] Retrieving CLOB data field from Oracle |
[eluser]fszostak[/eluser]
Hi All! After migration MySQL to Oracle, any fields with LONGTEXT datatype was change for CLOB datatype. 1) Error "Object of class OCI-Lob could not be converted to string" on field N.CONTENT (CLOB) Code: function getNews() { 2) Convert N.CONTENT to char... but received another error. Code: SELECT Error: ORA-22835:Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 6922, maximum: 4000) Please help me!!!! :-D
[eluser]fszostak[/eluser]
I found the solution in this thread http://ellislab.com/forums/viewthread/108172/#545496 Then i did create function to help. Code: function read_clob($field) { |
Welcome Guest, Not a member yet? Register Sign In |