| Storing XML tags Data in Oracle Table (merged) [message #416033] |
Thu, 30 July 2009 04:27  |
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 #416212 is a reply to message #416071] |
Fri, 31 July 2009 03:44  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
