Improve company productivity with a Business Account.Sign Up

x
?
Solved

An error occurred while retrieving the RSS feed.

Posted on 2012-04-13
6
Medium Priority
?
2,835 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:BILL Carlisle
  • 3
  • 3
6 Comments
 
LVL 19

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:BILL Carlisle
ID: 37843778
Found it gives error at this point:

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

Accepted Solution

by:
zc2 earned 560 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
LVL 2

Author Comment

by:BILL Carlisle
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:BILL Carlisle
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 19

Expert Comment

by:zc2
ID: 37843915
You're welcome
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
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…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

580 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