Home » Developer & Programmer » JDeveloper, Java & XML » Storing XML tags Data in Oracle Table (merged)
Storing XML tags Data in Oracle Table (merged) [message #416033] Thu, 30 July 2009 04:27 Go to next message
amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India
Member
Hi,

I need to store XML TAGS data in an Oracle Table.
Table Column names are almost same as Tags names.
I don't have any experience to load the same, so I gone through Oracle XML DB documentation but not able to figure out much.
Below are the XML and corresponding table command. Kindly help me to understand how I can do this.


<l:track dateTime = "2009-06-23 05:50:03.489" layerName = "XFTG" processName = "ValidOrder_1_0.repvalid" tType = "BEGIN" 	tStatus = ""  tCode = "" Oservnm = "" serverHostIP = "localhost/123.12.13.11" applicationID = "XLPO" providerID = "BSNL" originatorIP = "149.87.32.4" TransId = "76363729454:cadxp" OTrans = "i84j833-h34d-kkj8-pas3-8336ju0cdw3bb">
<xlp:repvalid xmlns:xlp="http://abc.co.in/repvalid_l" xmlns:xsi="http://www.abc.org/2009/XMLSchema-instance">
	<xlp:OperDate>1967-08-13</xlp:OperDate>
	<xlp:OrderIdentifier>
		<xlp:serialNumber>359885004708709</xlp:serialNumber>
	</xlp:OrderIdentifier>
              <xlp:orderIdentifier>
                             <xlp:OrdNum>o2-100000003</xlp:OrdNum>
                             <xlp:LnNum>1</xlp:LnNum>
                              <xlp:ProdNumber>1</xlp:ProdNumber>
              </xlp:orderIdentifier>
	<xlp:ProdCat>HAN</xlp:ProdCat>
	<xlp:IyNumber>447873834523</xlp:IyNumber>
	<xlp:VapDetails>
		<xlp:VapPart>ARS</xlp:VapPart>
		<xlp:Vaptype>RTN</xlp:Vaptype>
		<xlp:VapCode>104</xlp:VapCode>
		<xlp:VapSubCode>012</xlp:VapSubCode>
	</xlp:VapDetails>
	<xlp:CustomerDet>
		<xlp:CustId>AS7833HG</xlp:CustId>
		<xlp:CustCardId>GDTT897645G44909</xlp:CustCardId>
		<xlp:CreditLimit>56000</xlp:CreditLimit>
	</xlp:CustomerDet>
	<xlp:CommId>smily</xlp:CommId>
	<xlp:NARreq>true</xlp:NARreq>
</xlp:repvalid>
</l:track>


Table Structure
Create Table OrdTrack_Operations
(
Track_Date		Timestamp,
Layer_Name		Varchar2(10),
Process_Name		Varchar2(40),
Trans_Type		Varchar2(10),
Trans_Status		Varchar2(30),
Trans_Code		Varchar2(30),
Oserv_Name		Varchar2(30),
HostIP			Varchar2(30),
Appid			Varchar2(30),
ProviderId		Varchar2(30),
OriginatorIP		Varchar2(30),
Transid			Varchar2(50),	
OTransid		Varchar2(50), 	
Operdate		Timestamp,
SerialNo		Varchar2(30),
OrdNum			Varchar2(30),
LnNum			Integer,
ProdNum			Integer,
ProdCat			Varchar2(10),
IYnumber		Varchar2(20),
VapPart			Varchar2(10),
VapType			Varchar2(10),
VapCode			Varchar2(10),
VapSubCode		Varchar2(10),
CustId			Varchar2(30),
CustCardId		Varchar2(30),
CreditLimit		Number(17,2),
CommId			Varchar2(10),
NARreq			Varchar2(10)
);



Kindly Help
Regards
Amit
Re: Storing XML tags Data in Oracle Table (merged) [message #416045 is a reply to message #416033] Thu, 30 July 2009 04:53 Go to previous messageGo to next message
amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India
Member
Sorry Guys!! Confused

I've to do this work through an PL/SQL subprogram.

Regards
Amit
Re: Storing XML tags Data in Oracle Table (merged) [message #416071 is a reply to message #416045] Thu, 30 July 2009 06:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please post it.

Regards
Michel
Re: Storing XML tags Data in Oracle Table (merged) [message #416212 is a reply to message #416071] Fri, 31 July 2009 03:44 Go to previous messageGo to next message
amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India
Member
Dear Michel,

Did you mean whatever I've did, I should post that, if so then sorry to say but I'm not getting how to start.
I'm trying with SQL*Loader but as I mentioned, I've to perform this through a PL/SQL program.

Can you please assist me how to do this job. If I get an idea or so I can figure out some thing.

Thanx a lot
Regards
Amit

[Updated on: Fri, 31 July 2009 03:44]

Report message to a moderator

Re: Storing XML tags Data in Oracle Table (merged) [message #416213 is a reply to message #416212] Fri, 31 July 2009 03:56 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry I thought you've done it. I miss "to" in your sentence and read "I've to do" as "I've done".

Regards
Michel

Previous Topic: Deploy webservice
Next Topic: Display logged in user name
Goto Forum:
  


Current Time: Thu Mar 28 20:52:25 CDT 2024