XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Ajit ChhinaSubject: Loading data in XML file/document in an Oracle relational table.
Author: Ajit Chhina
Date: 22 Aug 2006 01:52 PM
Hello,
I am absolutely new to XML. I have a work at hand. I have an XML document, which is generated by the application. The requirement is to extract the data from the XML file/document and load it in the Oracle database in a relational table.

I need to know, firstly, is there any functionality in Stylus Studio to accomplish this task. Secondly, is there any other method to do this task. This has to be automated, as the files come in, the taskshould be done automatically.

Any input or advice is apprecaited.

Thanks,

Ajit

Posttop
Ivan PedruzziSubject: Loading data in XML file/document in an Oracle relational table.
Author: Ivan Pedruzzi
Date: 22 Aug 2006 06:05 PM
Ajit,

Please have a look to SQL/XML support in Stylus Studio

Chapter 12 "Accessing Relational Data as XML"
http://www.stylusstudio.com/docs/v2006R3/d_rdb.html

Video tutorial
http://www.stylusstudio.com/videos/dbtoxml2/dbtoxml2.html

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.