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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Update section of the BLOB column having both XML and encrypted data

User_QH2BLOct 15 2020

I have a BLOB column which start with encrypted data and then XML tags in English text. XML Tag always start with tags and always ends with and after that, we have another set of encrypted data.
We are not bothered about encrypted data, I want to update the complete XML content in this column starting from safetytable tag and ending with safetytable tag and replace it with another block of XML data example below without touching encrypted data.
I tried with the REPLACE function but it is not updating the data. Below is just the sample column data I gave. In actuality, I have XML data with huge chunk of XML File to be replaced.

BLOB Before update:

ąɂɸΏ◊●󠆻¥©◊●󠆻
  <safetytable>
  <safetytableid>E3223</safetytableid> 
  <transmissiondater>20201007105128-0700</transmissiondater> 
  <tabletype>2</tabletype> 
  </safetytable>"
ąɂɸΏ◊●󠆻¥©◊●󠆻

BLOB after update:

ąɂɸΏ◊●󠆻¥©◊●󠆻
<safetytable>
  <safetytableid>E322w2</safetytableid> 
  <transmissiondater>20201007105128-0700</transmissiondater> 
  <tabletype>1</tabletype> 
   <newelement1>3399494</newelement>
  <newelement2>009939</newelement>
    </safetytable>
ąɂɸΏ◊●󠆻¥©◊●󠆻

Comments

Processing

Post Details

Added on Oct 15 2020
#blob, #oracle, #plsql
0 comments
230 views