From vsharma@alletec.com Thu, 19 Jul 2001 00:41:08 -0700
From: vsharma@alletec.com
Date: Thu, 19 Jul 2001 00:41:08 -0700
Subject: retrieving XML from a url using oracle xml parser for plsql
Message-ID: <F001.0034E322.20010719002605@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: 



I Have installed Oracle XML Parser for  plsql and Oracle 
xml parser for java.I am trying to fetch xml from a url .I have performed 
following activitiesfrom sys database user   1) Created a 
class file and load it in database through 
loadjava      <FONT 
size=2>public class PropertyHelper{       
public static void setSystemProperty(String name,String value)  
{       
System.setProperty(name,value);       
}      }<FONT 
size=2>    2).  Created a procedure as language java to 
access this class         <FONT 
color=#0000ff>create or replace procedure 
setJavaSystemProperty(name String,value 
String)            as 
language java name 
'PropertyHelper.setSystemProperty(java.lang.String,java.lang.String)';<FONT 
size=2>    3). Created a procedure http_util for setting up the 
proxy server so taht my database server can directly talk to 
proxy        server internally. I login 
as sys user as it have all 
privileges                   
<FONT 
size=2>setJavaSystemProperty('proxySet','true');             
setJavaSystemProperty('proxyHost',host);             
setJavaSystemProperty('proxyPort',TO_CHAR(port));<FONT 
size=2>    4).  Written a simple procedure for fetching the 
xml from url 
retrieveXMLfromURL()              
http_util.setproxy(host => 
'proxyserverIP Address',port => 
'80');              
newsURL:='<A 
href="http://p.moreover.com/cgi-local/page?index_xml+xml';" target=_blank><FONT 
size=2>http://p.moreover.com/cgi-local/';<FONT 
color=#0000ff>              
newsURL:=newsURL || 
LTRIM(RTRIM(URL));              
parser:=xmlparser.newParser;              
newsXML:=xmlparser.parse(newsURL);              
xmlparser.freeparser(parser);      
5). I executed this procedure from sql prompt 
as          sql> <FONT 
color=#0000ff>exec 
retrieveXMLfromURL('page?index_xml+xml')         
and get the following error again and 
again         ERROR at line 
1:         ORA-20100: Error occurred 
while parsing: Connection 
refused         ORA-06512: at 
"SYS.XMLPARSER", line 23         
ORA-06512: at "SYS.XMLPARSER", line 
51         ORA-06512: at 
"SYS.RETRIEVEXMLFROMURL", line 
26         ORA-06512: at line 
1