I have a very large XML CLOB. within this CLOB I have a tag node named <users>.
This CLOB is sent into a PL/SQL procedure to update the tag node value.
So I have a procedure like this...
for example, within the said CLOB the <users> tag could look like this initially.
<users>unknown</users>
Then i call the following procedure.
After calling I am expecting the value of the <users> tag inside the CLOB to be updated
to have <users>John</users>
procedure update_node (p_clob in out nocopy clob) is
begin
--I have tried several PL/SQL DOM procedures/funcitons to update the p_clob but it did not work.
--Can someone write few lines here to show me how to update the value of tag <users> to be john?
end;