Parsing SOAP Response in PLSQL
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am trying to parse webservice SOAP response returned by a JAVA webservice in plsql. I am facing no error but i am getting nothing. Below is the code
WITH t as (select XMLTYPE('<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body>
<ns2:helloResponse xmlns:ns2="http://example.com/">
<ns2:return>Hello World</ns2:return>
</ns2:helloResponse>
</S:Body>
</S:Envelope>') as xml from dual)
select *
from t,
xmltable(XMLNAMESPACES('http://example.com/' as "ns2"),
'/Envelope/Body'
passing t.xml
columns myret varchar2(50) path '/ns2:helloResponse/ns2:return'
) x
What am i doing wrong here ?
oracle soap plsql xmltype
edited Nov 17 '18 at 8:03
Kaushik Nayak
22.5k41332
asked Nov 17 '18 at 7:25
Usman RiazUsman Riaz
1,41453254
add a comment |
I am trying to parse webservice SOAP response returned by a JAVA webservice in plsql. I am facing no error but i am getting nothing. Below is the code
WITH t as (select XMLTYPE('<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body>
<ns2:helloResponse xmlns:ns2="http://example.com/">
<ns2:return>Hello World</ns2:return>
</ns2:helloResponse>
</S:Body>
</S:Envelope>') as xml from dual)
select *
from t,
xmltable(XMLNAMESPACES('http://example.com/' as "ns2"),
'/Envelope/Body'
passing t.xml
columns myret varchar2(50) path '/ns2:helloResponse/ns2:return'
) x
What am i doing wrong here ?
oracle soap plsql xmltype
edited Nov 17 '18 at 8:03
Kaushik Nayak
22.5k41332
asked Nov 17 '18 at 7:25
Usman RiazUsman Riaz
1,41453254
add a comment |
I am trying to parse webservice SOAP response returned by a JAVA webservice in plsql. I am facing no error but i am getting nothing. Below is the code
WITH t as (select XMLTYPE('<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body>
<ns2:helloResponse xmlns:ns2="http://example.com/">
<ns2:return>Hello World</ns2:return>
</ns2:helloResponse>
</S:Body>
</S:Envelope>') as xml from dual)
select *
from t,
xmltable(XMLNAMESPACES('http://example.com/' as "ns2"),
'/Envelope/Body'
passing t.xml
columns myret varchar2(50) path '/ns2:helloResponse/ns2:return'
) x
What am i doing wrong here ?
oracle soap plsql xmltype
edited Nov 17 '18 at 8:03
Kaushik Nayak
22.5k41332
asked Nov 17 '18 at 7:25
Usman RiazUsman Riaz
1,41453254
I am trying to parse webservice SOAP response returned by a JAVA webservice in plsql. I am facing no error but i am getting nothing. Below is the code
WITH t as (select XMLTYPE('<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body>
<ns2:helloResponse xmlns:ns2="http://example.com/">
<ns2:return>Hello World</ns2:return>
</ns2:helloResponse>
</S:Body>
</S:Envelope>') as xml from dual)
select *
from t,
xmltable(XMLNAMESPACES('http://example.com/' as "ns2"),
'/Envelope/Body'
passing t.xml
columns myret varchar2(50) path '/ns2:helloResponse/ns2:return'
) x
What am i doing wrong here ?
oracle soap plsql xmltype
oracle soap plsql xmltype
edited Nov 17 '18 at 8:03
Kaushik Nayak
22.5k41332
asked Nov 17 '18 at 7:25
Usman RiazUsman Riaz
1,41453254
edited Nov 17 '18 at 8:03
Kaushik Nayak
22.5k41332
asked Nov 17 '18 at 7:25
Usman RiazUsman Riaz
1,41453254
edited Nov 17 '18 at 8:03
Kaushik Nayak
22.5k41332
edited Nov 17 '18 at 8:03
Kaushik Nayak
22.5k41332
edited Nov 17 '18 at 8:03
Kaushik Nayak
22.5k41332
22.5k41332
asked Nov 17 '18 at 7:25
Usman RiazUsman Riaz
1,41453254
asked Nov 17 '18 at 7:25
Usman RiazUsman Riaz
1,41453254
asked Nov 17 '18 at 7:25
Usman RiazUsman Riaz
1,41453254
1,41453254
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I can see a couple of issues here....
1) You have two namespaces (one for the envelope and body, and the other for the nodes) you need to account for both of these in your select
2) in your path for MyRet the context is from the envelope so you either need to specify the full path or use // at the beginning.
I am making some assumptions as to the output that you actually want but I think the below should work for you.
WITH t as (select XMLTYPE('<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body>
<ns2:helloResponse xmlns:ns2="http://example.com/">
<ns2:return>Hello World</ns2:return>
</ns2:helloResponse>
</S:Body>
</S:Envelope>') as xml from dual)
select *
from t,
xmltable(XMLNAMESPACES('http://example.com/' as "ns2", 'http://schemas.xmlsoap.org/soap/envelope/' as "S"),
'/S:Envelope/S:Body'
passing t.xml
columns myret varchar2(50) path '//ns2:helloResponse/ns2:return'
) x
answered Nov 19 '18 at 1:21
Shaun PetersonShaun Peterson
1,1231118
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53349161%2fparsing-soap-response-in-plsql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I can see a couple of issues here....
1) You have two namespaces (one for the envelope and body, and the other for the nodes) you need to account for both of these in your select
2) in your path for MyRet the context is from the envelope so you either need to specify the full path or use // at the beginning.
I am making some assumptions as to the output that you actually want but I think the below should work for you.
WITH t as (select XMLTYPE('<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body>
<ns2:helloResponse xmlns:ns2="http://example.com/">
<ns2:return>Hello World</ns2:return>
</ns2:helloResponse>
</S:Body>
</S:Envelope>') as xml from dual)
select *
from t,
xmltable(XMLNAMESPACES('http://example.com/' as "ns2", 'http://schemas.xmlsoap.org/soap/envelope/' as "S"),
'/S:Envelope/S:Body'
passing t.xml
columns myret varchar2(50) path '//ns2:helloResponse/ns2:return'
) x
answered Nov 19 '18 at 1:21
Shaun PetersonShaun Peterson
1,1231118
add a comment |
I can see a couple of issues here....
1) You have two namespaces (one for the envelope and body, and the other for the nodes) you need to account for both of these in your select
2) in your path for MyRet the context is from the envelope so you either need to specify the full path or use // at the beginning.
I am making some assumptions as to the output that you actually want but I think the below should work for you.
WITH t as (select XMLTYPE('<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body>
<ns2:helloResponse xmlns:ns2="http://example.com/">
<ns2:return>Hello World</ns2:return>
</ns2:helloResponse>
</S:Body>
</S:Envelope>') as xml from dual)
select *
from t,
xmltable(XMLNAMESPACES('http://example.com/' as "ns2", 'http://schemas.xmlsoap.org/soap/envelope/' as "S"),
'/S:Envelope/S:Body'
passing t.xml
columns myret varchar2(50) path '//ns2:helloResponse/ns2:return'
) x
answered Nov 19 '18 at 1:21
Shaun PetersonShaun Peterson
1,1231118
add a comment |
I can see a couple of issues here....
1) You have two namespaces (one for the envelope and body, and the other for the nodes) you need to account for both of these in your select
2) in your path for MyRet the context is from the envelope so you either need to specify the full path or use // at the beginning.
I am making some assumptions as to the output that you actually want but I think the below should work for you.
WITH t as (select XMLTYPE('<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body>
<ns2:helloResponse xmlns:ns2="http://example.com/">
<ns2:return>Hello World</ns2:return>
</ns2:helloResponse>
</S:Body>
</S:Envelope>') as xml from dual)
select *
from t,
xmltable(XMLNAMESPACES('http://example.com/' as "ns2", 'http://schemas.xmlsoap.org/soap/envelope/' as "S"),
'/S:Envelope/S:Body'
passing t.xml
columns myret varchar2(50) path '//ns2:helloResponse/ns2:return'
) x
answered Nov 19 '18 at 1:21
Shaun PetersonShaun Peterson
1,1231118
I can see a couple of issues here....
1) You have two namespaces (one for the envelope and body, and the other for the nodes) you need to account for both of these in your select
2) in your path for MyRet the context is from the envelope so you either need to specify the full path or use // at the beginning.
I am making some assumptions as to the output that you actually want but I think the below should work for you.
WITH t as (select XMLTYPE('<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body>
<ns2:helloResponse xmlns:ns2="http://example.com/">
<ns2:return>Hello World</ns2:return>
</ns2:helloResponse>
</S:Body>
</S:Envelope>') as xml from dual)
select *
from t,
xmltable(XMLNAMESPACES('http://example.com/' as "ns2", 'http://schemas.xmlsoap.org/soap/envelope/' as "S"),
'/S:Envelope/S:Body'
passing t.xml
columns myret varchar2(50) path '//ns2:helloResponse/ns2:return'
) x
answered Nov 19 '18 at 1:21
Shaun PetersonShaun Peterson
1,1231118
answered Nov 19 '18 at 1:21
Shaun PetersonShaun Peterson
1,1231118
answered Nov 19 '18 at 1:21
Shaun PetersonShaun Peterson
1,1231118
answered Nov 19 '18 at 1:21
Shaun PetersonShaun Peterson
1,1231118
1,1231118
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53349161%2fparsing-soap-response-in-plsql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
