Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> retrieving XML from a url using oracle xml parser for plsql

retrieving XML from a url using oracle xml parser for plsql

From: <vsharma_at_alletec.com>
Date: Thu, 19 Jul 2001 00:41:08 -0700
Message-ID: <F001.0034E322.20010719002605@fatcity.com>

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 Received on Thu Jul 19 2001 - 02:41:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US