Hi Experts,
I am new to PL/SQL,I am using oracle 10g
I need to
- Read XML file from applications server
- parse that file
- and then printing the data
<?xml version="1.0" encoding="UTF-8" ?>
<Document xmlns="urn:iso:std:iso:20022:tech:xsd:camt.053.001.02" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<BkToCstmrStmt>
<GrpHdr>
<MsgId>20141126215541854159</MsgId>
<CreDtTm>2014-11-26T19:00:00.000+01:00</CreDtTm>
<MsgRcpt>
<Nm>Hotel roychand</Nm>
<PstlAdr>
<AdrLine>c/o Roychand Creations</AdrLine>
<AdrLine>Red fort</AdrLine>
<AdrLine>EAST DELHI</AdrLine>
<AdrLine>India</AdrLine>
</PstlAdr>
</MsgRcpt>
<MsgPgntn>
<PgNb>1</PgNb>
<LastPgInd>true</LastPgInd>
</MsgPgntn>
</GrpHdr>
<Stmt>
<Id>34471065430325820141126215541854159</Id>
<ElctrncSeqNb>198</ElctrncSeqNb>
<CreDtTm>2014-11-26T19:00:00.000+01:00</CreDtTm>
<FrToDt>
<FrDtTm>2014-11-26T00:00:00.000+01:00</FrDtTm>
<ToDtTm>2014-11-26T24:00:00.000+01:00</ToDtTm>
</FrToDt>
<Acct>
<Id>
<IBAN>IN11700202700654303289</IBAN>
</Id>
<Ccy>EUR</Ccy>
<Ownr>
<Nm>Duster creations GMBH</Nm>
<PstlAdr>
<AdrLine>c/o Dusters Spa</AdrLine>
<AdrLine>Piazza dei Giustiniani 6</AdrLine>
<AdrLine>16123 Genova</AdrLine>
<AdrLine>Italy</AdrLine>
</PstlAdr>
</Ownr>
<Svcr>
<FinInstnId>
<BIC>HYVEDEMMXXX</BIC>
<Nm>UNICREDIT BANK AG</Nm>
<Othr>
<Id>DE 129273339</Id>
<Issr>UmsStId</Issr>
</Othr>
</FinInstnId>
</Svcr>
</Acct>
<Bal>
<Tp>
<CdOrPrtry>
<Cd>PRCD</Cd>
</CdOrPrtry>
</Tp>
<Amt Ccy="EUR">3383607.41</Amt>
<CdtDbtInd>CRDT</CdtDbtInd>
<Dt>
<Dt>2014-11-25</Dt>
</Dt>
</Bal>
<Bal>
<Tp>
<CdOrPrtry>
<Cd>CLBD</Cd>
</CdOrPrtry>
</Tp>
<Amt Ccy="EUR">2613059.96</Amt>
<CdtDbtInd>CRDT</CdtDbtInd>
<Dt>
<Dt>2014-11-26</Dt>
</Dt>
</Bal>
<Bal>
<Tp>
<CdOrPrtry>
<Cd>CLAV</Cd>
</CdOrPrtry>
</Tp>
<Amt Ccy="EUR">2613059.96</Amt>
<CdtDbtInd>CRDT</CdtDbtInd>
<Dt>
<Dt>2014-11-26</Dt>
</Dt>
</Bal>
<Ntry>
<Amt Ccy="EUR">770547.45</Amt>
<CdtDbtInd>DBIT</CdtDbtInd>
<Sts>BOOK</Sts>
<BookgDt>
<Dt>2014-11-26</Dt>
</BookgDt>
<ValDt>
<Dt>2014-11-26</Dt>
</ValDt>
<AcctSvcrRef>0932690037020932</AcctSvcrRef>
<BkTxCd></BkTxCd>
<NtryDtls>
<Btch>
<MsgId>52054</MsgId>
<PmtInfId>52054</PmtInfId>
<NbOfTxs>3</NbOfTxs>
<TtlAmt Ccy="EUR">770547.45</TtlAmt>
<CdtDbtInd>DBIT</CdtDbtInd>
</Btch>
<TxDtls>
<Refs>
<MsgId>52054</MsgId>
<PmtInfId>52054</PmtInfId>
<ClrSysRef>CTD141126KEGE019156</ClrSysRef>
</Refs>
<BkTxCd>
<Prtry>
<Cd>NTRF+191+50</Cd>
<Issr>ZKA</Issr>
</Prtry>
</BkTxCd>
<RltdPties>
<InitgPty>
<Nm>ORG_ALMO DE</Nm>
</InitgPty>
</RltdPties>
<RmtInf>
<Ustrd>SEPA-ÜBERWEISUNGSDATEI ZAHLUNGSREFERENZ 52054 POSTEN 3 DATEI CTD141126KEGE019156</Ustrd>
</RmtInf>
<RltdDts>
<Prtry>
<Tp>CreationDateTime of Payment Order</Tp>
<Dt>
<DtTm>2014-11-26T10:04:01.000+01:00</DtTm>
</Dt>
</Prtry>
</RltdDts>
</TxDtls>
</NtryDtls>
<AddtlNtryInf>SEPA-Ueberweisungsdatei</AddtlNtryInf>
</Ntry>
</Stmt>
</BkToCstmrStmt>
</Document>
Can any one please help me to write pl/sql procedure.
Thanks in advance
Jenney