Solved

An error occurred while retrieving the RSS feed.

Posted on 2012-04-13
6
2,352 Views
Last Modified: 2013-11-18
Hi All,
I get this as first line in RSS feed and it gives error

¿<?xml version="1.0" encoding="utf-8"?>

Do I need to replace ¿ with empty string before reading?



An error occurred while retrieving the RSS feed.
Complete database error message:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00210: expected '<' instead of '¿'
Error at line 1

Feed content:
¿<?xml version="1.0" encoding="utf-8"?>
<rss xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:x-microsoft="http://schemas.microsoft.com/x-microsoft" xmlns:x-trumba="http://schemas.trumba.com/rss/x-trumba" version="2.0">
      <channel>
            <title>Arrow ECS Education Calendar</title>
            <link>http://ecs.arrow.com/services/education_calendar.html</link>
            <description />
            <language>en-us</language>
            <lastBuildDate>02 Apr 2012 19:27:34 GMT</l
0
Comment
Question by:bcarlis
  • 3
  • 3
6 Comments
 
LVL 18

Expert Comment

by:zc2
ID: 37843517
Looks like the Byte Order Mark (http://en.wikipedia.org/wiki/Byte_order_mark) is not recognized by your parser.
0
 
LVL 2

Author Comment

by:bcarlis
ID: 37843778
Found it gives error at this point:

  l_rss_xml := sys.httpuritype(l_rss_url).getxml();
0
 
LVL 18

Accepted Solution

by:
zc2 earned 140 total points
ID: 37843835
What's the development environment are you using... What is it, Pascal, Delphi?..
You should ask a question in the related zone or study its documentation about how does it tolerate the UNICODE text format. If you find out it does not support UNICODE, then, you can try to find an utility which converts UTF-8 to ASCII and use it before feeding the text to the XML parser. As an another approach,  just remove the leading BOM bytes by yourself.
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
LVL 2

Author Comment

by:bcarlis
ID: 37843905
I'm in PL/SQL... good idea... but I got it!
I changed the "Override Feed Encoding" from "Auto Detect" to "UTF-8" and that did it!
Thank you for your help
0
 
LVL 2

Author Comment

by:bcarlis
ID: 37843912
Actually it was more the "Byte Order Mark" comment that lead me to try the different setting... I clicked to fast...
0
 
LVL 18

Expert Comment

by:zc2
ID: 37843915
You're welcome
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
XSLT Help 12 34
JQuery to parse xml string and get element by id 4 64
TSQL query to generate xml 4 54
Run a Radio Station (Streaming media) with web interface 10 48
Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question