Solved

An error occurred while retrieving the RSS feed.

Posted on 2012-04-13
6
2,499 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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, …
Introduction Knockoutjs (Knockout) is a JavaScript framework (Model View ViewModel or MVVM framework).   The main ideology behind Knockout is to control from JavaScript how a page looks whilst creating an engaging user experience in the least …
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Suggested Courses

635 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