OraFAQ Forum: JDeveloper, Java & XML » Oracle XMLparser- access Non-oracle generated xml files

Home » Developer & Programmer » JDeveloper, Java & XML » Oracle XMLparser- access Non-oracle generated xml files

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle XMLparser- access Non-oracle generated xml files [message #131368]

Fri, 05 August 2005 10:28

mpinvitesu
Messages: 15
Registered: July 2005

Junior Member

Hi,

I am trying to parse an XML using oracle xmlparser in PL/SQL like

xmlparser.parse(par, in_xml);

But the above statement works fine if the in_xml is created by oracle process itself. If the in_xml is created by the operating system by any other user it's throwing an error..

EXCEPTION = -20100,ORA-20100: Error occurred while parsing: No such file or directory

How to grant permission to oracle to access any files generated by any other non-oracle process.

Report message to a moderator

Re: Oracle XMLparser- access Non-oracle generated xml files [message #131532 is a reply to message #131368]

Mon, 08 August 2005 02:05

b_chugh
Messages: 68
Registered: August 2005
Location: delhi

Member

Sorry I am not aware.

I was also trying to create XML from the oracle table. Please let me know How to create XML file from oracle table.

Report message to a moderator

Re: Oracle XMLparser- access Non-oracle generated xml files [message #131832 is a reply to message #131532]

Tue, 09 August 2005 11:59

mpinvitesu
Messages: 15
Registered: July 2005

Junior Member

Have a look at the following link

www.akadia.com/services/ora_gen_xml.html

You will have a good idea on various methods used to create XML from oracle

Regards,
Prakash

Report message to a moderator

Re: Oracle XMLparser- access Non-oracle generated xml files [message #131884 is a reply to message #131832]

Tue, 09 August 2005 23:27

b_chugh
Messages: 68
Registered: August 2005
Location: delhi

Member

HELLO DEAR

SELECT xmlgen.getXml(
'SELECT QUENBR "QUENBR"
, QUETYPCD "QUETYP CODE"
, TEMPLATEYN "TEMPLATEYN"
FROM QUE
WHERE QUENBR>32225'
, 0
) FROM dual;

ORA-00904 INVALID IDENTIFIER xmlgen.getXml

pls help how i can use this package.

Report message to a moderator

Previous Topic:	PL SQL Error
Next Topic:	LOADJAVA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 01:19:28 CST 2024