DevOps, CI/CD and Automation

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!

dynamic tag updation in xml

Ramuplsql10May 14 2018 — edited May 17 2018

Hi,

My requirement is i have clob column for encryption of data purpose I want to update the tag values in the XML.

I want to create the one procedure like test_Clob(p_input_tag_name varchar2, P_tag_update_Value varchar2)

Note: Tag name will come dynamically, and update value also dynamic.

Is there any chance to search the tag name from the root node(we don't know the exact path) if it's there want to update the value.

My DB version is 11.2

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 14 2018

Added on May 14 2018

#pl-sql-xml-programming, #xml

5 comments

2,295 views