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
public class PropertyHelper{
public static void setSystemProperty(String name,String value)
{
System.setProperty(name,value);
}
}
2). Created a procedure as language java to
access this class
create or replace procedure
setJavaSystemProperty(name String,value
String)
as
language java name
'PropertyHelper.setSystemProperty(java.lang.String,java.lang.String)';
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
setJavaSystemProperty('proxySet','true');
setJavaSystemProperty('proxyHost',host);
setJavaSystemProperty('proxyPort',TO_CHAR(port));
4). Written a simple procedure for fetching the
xml from url
retrieveXMLfromURL()
http_util.setproxy(host =>
'proxyserverIP Address',port =>
'80');
newsURL:='http://p.moreover.com/cgi-local/';
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> 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
Title: