CREATE TABLE tmp_rpt (xmlcol SYS.XMLTYPE)
INSERT INTO tmp_rpt
VALUES ('<DRP>ÉÉÉÉ</DRP>')
COMMIT
DECLARE
CURSOR c
IS
SELECT XMLSERIALIZE (DOCUMENT xmlcol AS CLOB) AS CLOB
FROM tmp_rpt x;
xml_val CLOB;
BEGIN
FOR i IN (SELECT XMLSERIALIZE (DOCUMENT xmlcol AS CLOB) AS val
FROM tmp_rpt)
LOOP
xml_val := i.val;
-- DBMS_OUTPUT.put_line ('' || xml_val); --return correct value
DBMS_OUTPUT.put_line (xml_val); -- truncates 2 characters from left
dbms_output.put_line('length:'||length(xml_val));
END LOOP;
END;
DROP TABLE tmp_rpt