Oracle pl/sql ..... soap api question

[DeepBlue]

Ahh. I was going to say. Been there before. The namespace handling in the Oracle library is tulip.

I decompiled a bunch of that java and gave up in the end. On the whole stinking API. Wrote a Servlet to do the heavy lifting and invoked that!

[css_jay99]

Thanks guys,

the webservice provider pulled the namespace off the wrappedResponse element, so was able extract the success attribute.

css_jay99

[Weltchy]

Not sure about any obscure xPath synxtax in PL/SQL, as normally it would be '/soapStatus/@success' so can't comment on the way to access the success attribute.

Take a look at http://www.mercatorgeosystems.com/blog/?p=5 which seems to indicate using the '/' before the attribute.

Also, as donkey said, don't mess up your namespaces. Use either '/ns1:soapStatus@success' with a namespace declaration of 'xmlns:ns1="http://cuk.com/ccuk/schema' or drop off the namespace declaration altogether.

[css_jay99]

I''ll give that a try when i get into work

cheers

css_jay99

[donkeykungpochicken]

...

<ns1:wrappedResponse xmlns:ns1 "http://cuk.com/res/cukwebservice/actions/">
<soapStatus xmlns="http://cuk.com/ccuk/schema" success="true"/>
</ns1:wrappedResponse>

I am trying to xtract the value of the attribute success
I tried something like

p_value := t_response.extract('/soapStatus@success','xmlns:ns1="http://cuk.com/ccuk/schema"').getStringVal();

but just kep getting ... ORA-30625: method dispatch on NULL SELF argument is disallowed....
...
css_jay99

I think more like

p_value := t_response.extract('/soapStatus@success','xmlns="http://cuk.com/ccuk/schema"').getStringVal();

or

p_value := t_response.extract('/ns1:soapStatus@success','xmlns:ns1="http://cuk.com/ccuk/schema"').getStringVal();

Isn't the soapStatus element in the "http://cuk.com/ccuk/schema" namespace, so you need to either declare that as the default namespace, or actually use the 'ns1' alias you are defining.

Also I'd probably be checking that the result of the extract is not null before calling the getStringVal operation (to avoid the error)

Perhaps...

[mudskipper]

Shouldn't that be /soapStatus/@success ?

[d000hg]

I have absolutely no idea what that even means.

[AtW]

That made me feel a bit

Shush, or you'll be locked up again!

[d000hg]

I am trying to extract a value from a soap api request in pl/sql

That made me feel a bit

[css_jay99]

I had already googled but no luck with the issue since the error code is implying that I am passing null/missing xml to the method which I am not



css_jay99

[Moscow Mule]

Nothing specific, but I normally just google the error code when I get that sort of gubbins...

http://www.google.co.uk/search?sourc...=lr%3D&aq=&oq=

[css_jay99]

Hi,

I am trying to extract a value from a soap api request in pl/sql

variable t_response is an xmltype returned from soap api
t_response has the following xml value below
<ns1:wrappedResponse xmlns:ns1 "http://cuk.com/res/cukwebservice/actions/">
<soapStatus xmlns="http://cuk.com/ccuk/schema" success="true"/>
</ns1:wrappedResponse>

I am trying to xtract the value of the attribute success
I tried something like

p_value := t_response.extract('/soapStatus@success','xmlns:ns1="http://cuk.com/ccuk/schema"').getStringVal();

but just kep getting ... ORA-30625: method dispatch on NULL SELF argument is disallowed....

any clues?

css_jay99