No question at this time
DBA Top 10
1 M. Cadot 10400
2 A. Kavsek 7600
3 B. Vroman 4800
4 P. Wisse 4000
5 J. Schnackenberg 3200
6 J. PĂ©ran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48536
Total active users1398
Act. users last 24h2
Act. users last hour0
Registered user hits last week128
Registered user hits last month434
Go up

How to use ExtractValue function in my XML?
Next thread: Difference of sql execution time in awr and dba_hist_sqlstat.
Prev thread: Goldengate Bidirectional Replication with CDR

Message Score Author Date
Hi, All <b>How to pull ID value from below XML us...... Jayan Kumar T Sep 03, 2015, 21:39
Appreciate anyone help here. Regards Jayan... Jayan Kumar T Sep 08, 2015, 19:35

Follow up by mail Click here


Subject: How to use ExtractValue function in my XML?
Author: Jayan Kumar T, India
Date: Sep 03, 2015, 21:39, 1849 days ago
Os info: WinXP
Oracle info: 11.2.0.2.0
Message: Hi, All
How to pull ID value from below XML using EXTRACTVALUE function?


<?xml version="1.0" encoding="UTF-8"?>
<ab-response xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="ab-response.xsd">
<Id>394018</Id>
</ab-response>


How to pull RecordType value from below XML using EXTRACTVALUE function?
<?xml version="1.0" encoding="UTF-8"?>
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<env:Header>
<AuthenticationHeader xmlns="http://abc.com/FeedService">
<UserName>holiday</UserName>
<Password>1244</Password>
</AuthenticationHeader>
</env:Header>
<env:Body>
<m:Submit xmlns:m="http://abc.com/FeedService">
<m:Request>
<m:RecordType>R</m:RecordType>
</m:Request>
</m:Submit>
</env:Body>
</env:Envelope>


Regards
Jayan
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How to use ExtractValue function in my XML?
Author: Jayan Kumar T, India
Date: Sep 08, 2015, 19:35, 1844 days ago
Message: Appreciate anyone help here.

Regards
Jayan
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here