DECLARE 
     l_pieces  utl_http.html_pieces;
      l_url     varchar2(32767) default  'http://www.gsmarena.com/sony_ericsson_spiro-3267.php'; 
     l_page     clob;
 
BEtGIN
    
      -- get html pieces from main url and put page into clob:
     dbms_lob.createtemporary (l_page, TRUE);
     l_pieces := utl_http.request_pieces(l_url);
     for i in 1 .. l_pieces.count loop
        l_page := l_page || l_pieces(i);
        
          --DBMS_OUTPUT.PUT_LINE(l_pieces(i) );
     end loop;
        
    -- free temporary clob:
        dbms_lob.freetemporary (l_page);
  -- end loop;
 end;

ORA-01482: unsupported character set
 *Cause: The character set used to perform the operation, such as
        the CONVERT function, is not a supported character set.
 *Action:  Use one of the supported character sets.