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