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
