Hi,
I am getting an error "numeric or value error " for the below code
PROCEDURE PRC_CREATE_TEMP_CLOB(pi_original_clob IN OUT NOCOPY CLOB) IS
l_tmp_clob clob;
BEGIN
dbms_lob.createtemporary(l_tmp_clob, TRUE, dbms_lob.session);
XmlDom.writeToClob(domDocument,l_tmp_clob);
dbms_lob.write(pi_original_clob,dbms_lob.getlength(l_tmp_clob),1,l_tmp_clob);
END;
The error comes in the statement "dbms_lob.write"
Any idea what can be the error?
Thanks