BILL Carlisle
asked on
An error occurred while retrieving the RSS feed.
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
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
Looks like the Byte Order Mark (http://en.wikipedia.org/wiki/Byte_order_mark) is not recognized by your parser.
ASKER
Found it gives error at this point:
l_rss_xml := sys.httpuritype(l_rss_url) .getxml();
l_rss_xml := sys.httpuritype(l_rss_url)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
I changed the "Override Feed Encoding" from "Auto Detect" to "UTF-8" and that did it!
Thank you for your help
ASKER
Actually it was more the "Byte Order Mark" comment that lead me to try the different setting... I clicked to fast...
You're welcome