Home » Developer & Programmer » JDeveloper, Java & XML » Equivalent type in PLSQL for Complex type Data of XML file
Equivalent type in PLSQL for Complex type Data of XML file [message #193765] Tue, 19 September 2006 06:00
Messages: 1
Registered: September 2006
Location: Bangalore
Junior Member
I have a XSD file from which I need to generate XML and load that XML file data into my Oracle 9i database. (9.2).I have seen the XDK kit and XML DB procedures and understood how to generate xml files and insert xml data into database tables. My problem is the XML file contains complex types which have a hierarchy relationship. The complex type attributes contains another complex type and it goes on like this. I need to create the table in Oracle for loading this XML data. I would like to know what kind of data type (which user defined data type) will be better to use to represent the complex type data in Oracle.

Can anybody please help? Thank you !
Previous Topic: How to relocate buttons on standard OA page
Next Topic: Javascript error when user enters maximum characters in MessageTextInput
Goto Forum:

Current Time: Mon Jul 24 20:15:27 CDT 2017

Total time taken to generate the page: 0.10154 seconds