Home » Developer & Programmer » JDeveloper, Java & XML » get specs from html (Oracle 11g)
get specs from html [message #541497] Tue, 31 January 2012 13:35 Go to next message
mape
Messages: 298
Registered: July 2006
Location: Slovakia
Senior Member
Hello

I need to get some mobile specs from html page into table.

First of all its needed to get html pieces from main url and put page into clob (see below).

When I do this I get an errors:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1819
ORA-01482: unsupported character set
ORA-06512: at line 10


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;


Could you please tell me how is a possible to do that?

Thanks all

Re: get specs from html [message #541502 is a reply to message #541497] Tue, 31 January 2012 14:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.


Regards
Michel
Re: get specs from html [message #541504 is a reply to message #541502] Tue, 31 January 2012 14:45 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Are you saying that you learnt nothing from your previous, exactly the same problem?
Re: get specs from html [message #541529 is a reply to message #541504] Tue, 31 January 2012 23:25 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From all his previous questions, the answer is "I indeed learn nothing". Smile

Regards
Michel
Previous Topic: Creating a new row in a table by taking values from another table as parameters
Next Topic: how to add some value in already present node in xml type clob column
Goto Forum:
  


Current Time: Fri Mar 29 03:41:48 CDT 2024