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
JJaya
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 !

Report message to a moderator

Previous Topic: How to relocate buttons on standard OA page
Next Topic: Javascript error when user enters maximum characters in MessageTextInput
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 00:44:49 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.