UTL_HTTP problem

From: avin <avinthr_at_yahoo.co.uk>
Date: 29 Aug 2003 07:04:22 -0700
Message-ID: <a1c3c00e.0308290604.f9af5e1@posting.google.com>

Hi

I am trying to get an html page into a table using the utl_http package. However the script that I execute has the follwoing problems, can anyone shed some light.

 declare pieces utl_http.html_pieces;
  2 begin
  3 pieces := utl_http.request_pieces('http://www.oracle.com/');   4 for i in 1 .. pieces.count loop
  5 dbms_output.put_line('pieces');
  6 end loop;
  7 exception

  8     when utl_http.init_failed theN
  9     NULL;

 10 END;
 11* -- end;
16:00:10 batch:dbop_at_dev8 SQL> /
declare pieces utl_http.html_pieces;
*
ERROR at line 1:

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_HTTP", line 126
ORA-06512: at line 3

Regards
A.V Received on Fri Aug 29 2003 - 09:04:22 CDT