DECLARE 
     l_pieces  utl_http.html_pieces;
      l_url     varchar2(32767) default  'http://www.mobitola.sk/phones/Sony_Ericsson/C702/'; 
     l_page     clob;
 
BEGIN
    
      -- 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;
     
      -- do whatever needs to be done to convert the html to valid xml:
        l_page := substr (l_page, instr (l_page, 'základné údaje'));
        l_page := substr (l_page, 1, instr (l_page, 'podpora WCSS') + 7);
   
        DBMS_OUTPUT.PUT_LINE(l_page);

 -- free temporary clob:
        dbms_lob.freetemporary (l_page);
  -- end loop;
 end;

SQL> DECLARE 
  2       l_pieces  utl_http.html_pieces;
  3        l_url     varchar2(32767) default  'http://www.mobitola.sk/phones/Sony_Ericsson/C702/'; 
  4       l_page     clob;
  5   
  6  BEGIN
  7      
  8        -- get html pieces from main url and put page into clob:
  9       dbms_lob.createtemporary (l_page, TRUE);
 10       l_pieces := utl_http.request_pieces(l_url);
 11       for i in 1 .. l_pieces.count loop
 12          l_page := l_page || l_pieces(i);
 13          
 14            --DBMS_OUTPUT.PUT_LINE(l_pieces(i) );
 15       end loop;
 16       
 17        -- do whatever needs to be done to convert the html to valid xml:
 18          l_page := substr (l_page, instr (l_page, 'základné údaje'));
 19          l_page := substr (l_page, 1, instr (l_page, 'podpora WCSS') + 7);
 20     
 21          DBMS_OUTPUT.PUT_LINE(l_page);
 22  
 23   -- free temporary clob:
 24          dbms_lob.freetemporary (l_page);
 25    -- end loop;
 26   end;
 27  /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 21

declare
  ...
begin
  ...
  dbms_output.put_line (l_page);
  ...
end;
/

variable g_ref refcursor
declare
  ...
begin
  ...
  open :g_ref for select l_page from dual;
  ...
end;
/
print g_ref

SCOTT@orcl_11gR2> VARIABLE g_ref REFCURSOR
SCOTT@orcl_11gR2> DECLARE
  2  	  l_pieces  UTL_HTTP.HTML_PIECES;
  3  	  l_url     VARCHAR2(32767) DEFAULT 'http://www.mobitola.sk/phones/Sony_Ericsson/C702/';
  4  	  l_page    CLOB;
  5  BEGIN
  6  	  -- get html pieces from main url and put page into clob:
  7  	  DBMS_LOB.CREATETEMPORARY (l_page, TRUE);
  8  	  l_pieces := UTL_HTTP.REQUEST_PIECES (l_url);
  9  	  FOR i in 1 .. l_pieces.COUNT LOOP
 10  	     l_page := l_page || l_pieces(i);
 11  	  END LOOP;
 12  
 13  	  -- do whatever needs to be done to convert the html to valid xml:
 14  	  l_page := SUBSTR (l_page, INSTR (l_page, 'základné údaje'));
 15  	  l_page := SUBSTR (l_page, 1, INSTR (l_page, 'podpora WCSS') + 7);
 16  
 17  	  OPEN :g_ref FOR SELECT l_page FROM DUAL;
 18  
 19  	  -- free temporary clob:
 20  	  DBMS_LOB.FREETEMPORARY (l_page);
 21  END;
 22  /

PL/SQL procedure successfully completed.

SCOTT@orcl_11gR2> PRINT g_ref

:B1
--------------------------------------------------------------------------------
základné údaje</h3></td></tr>

... truncated to save space

    <td width="50%"><img src="/images/pu.png"  width=12 height=12> podpora


1 row selected.

SCOTT@orcl_11gR2>