SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Read XML from nested nodes using namespace

Raj_insightFeb 4 2018 — edited Feb 7 2018

Dear Experts,

I'm facing some issue while reading the XML payload which contains nested nodes.

Not sure, if I'm doing some thing wrong, I'm not able to get the desired output. Please help me to correct:

here's my livesql script:

https://livesql.oracle.com/apex/livesql/file/content_F742EXBMSOIEU7IEC3IQYCXEI.html

run below statement:

EXEC test_xml_raj;

Expectation: it should print below.

l_cmilocation = P44-I44-P6-100

which is not happening, getting NO DATA FOUND.

This post has been answered by Paulzip on Feb 5 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2018

Added on Feb 4 2018

5 comments

503 views