Skip to Main Content

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!

how to update XML node with PL/SQL

Big PangOct 11 2018 — edited Oct 18 2018

I can't figure out how to put PL/SQL function inside XMLQuery update statement.

i.e

SELECT

XMLQuery('copy $i := $p1 modify

                    ( for $j in $i//Company return replace value of node $j with "my PL/SQL function (this node)" )

                  return $i'

                  PASSING

                              MyData AS "p1"

                    RETURNING CONTENT)

from MyTable;

BTW, I tried '||' , it doesn't work.

This post has been answered by cormaco on Oct 11 2018
Jump to Answer
Comments
Post Details
Added on Oct 11 2018
12 comments
8,549 views