Encode clob greater than 32k to base64
rknadenFeb 5 2010 — edited Mar 11 2010Hi.
I have to pass xml-data greater than 32k encoded to base64 to a webservice.
For data less than 32k I have it encoded by:
l_value := utl_encode.text_encode(l_value, 'UTF8', UTL_ENCODE.BASE64);
where l_value is a clob containing my xml.
But for data >32k I get the exception "ORA-06502: PL/SQL: numerischer oder Wertefehler".
Can anybody tell me how to do the conversion?
Thanks.
Rolf