Solved

An error occurred while retrieving the RSS feed.

Posted on 2012-04-13
6
2,208 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
What is Node.js? Node.js is a server side scripting language much like PHP or ASP but is used to implement the complete package of HTTP webserver and application framework. The difference is that Node.js’s execution engine is asynchronous and event…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
The viewer will learn how to count occurrences of each item in an array.

930 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now