Skip to Main Content
Forums

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!

How to replace a part of BLOB(XML)

claudioaragaoFeb 23 2010 — edited Apr 13 2012
Hi.

I would like to know how replace a part of BLOB.
For example, I have this code

<inscSufDestinatario>999999999</inscSufDestinatario>
<ufDestino>MG</ufDestino>
<ufOrigem>SP</ufOrigem>
<qtdeNF>#1</qtdeNF>
<notasFiscais>

and I need replace the "#1" for "5" or "10" and store him again in a blob.
I wait have been clear.
Tks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2012
Added on Feb 23 2010
8 comments
3,045 views