OraFAQ Forum: Forms » Parsing XML file using Oracle Forms?

Home » Developer & Programmer » Forms » Parsing XML file using Oracle Forms?

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

Parsing XML file using Oracle Forms? [message #125178]

Thu, 23 June 2005 12:40

jonet01
Messages: 5
Registered: June 2005

Junior Member

Can anyone tell me if a) is it possible to parse an XML file directly with Oracle Forms, and b) if it is, how is it achieved?

thanks in advanced for any help provided!

Tony

Report message to a moderator

Re: Parsing XML file using Oracle Forms? [message #125224 is a reply to message #125178]

Thu, 23 June 2005 20:12

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to http://www.oracle.com/technology/tech/xml/index.html and start from there.

Idea: Create XML database, define a table as external file and open your XML file to it. It might work, it does for flat files.

David

Report message to a moderator

Re: Parsing XML file using Oracle Forms? [message #125293 is a reply to message #125178]

Fri, 24 June 2005 04:46

jonet01
Messages: 5
Registered: June 2005

Junior Member

How do you define a table as an external file then? Sorry, but I'm new to XML in an Oracle context.

Tony

Report message to a moderator

Re: Parsing XML file using Oracle Forms? [message #125482 is a reply to message #125293]

Sun, 26 June 2005 20:12

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_7002.htm#SQLRF01402, look down the page for 'XMLType_table' and then 'physical_properties'. I don't know if it works, but have a look, and give it a try.

To see what the internals of the external file look like, define a simple table with three or four fields, use the table and data enter two or three records, then open the file and review its contents.

Alternatively, ask your question in the database forum.

David

[Updated on: Mon, 27 June 2005 03:18]

Report message to a moderator

Previous Topic:	What is wrong???
Next Topic:	Problem in creating mirror item in 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:11:25 CDT 2024