hello Experts,
i have a table cert_config , which has blob column "configuration_xml". now i need to update the data in the column, highlighted below.
SQL> desc cert_config
Name Null? Type
----------------------------------------- -------- ----------------------------
IDC_ID NOT NULL NUMBER(19)
CONFIGURATION_XML NOT NULL BLOB >>>>>>>
CREATEDATE NOT NULL DATE
CREATEUSER NOT NULL VARCHAR2(50 CHAR)
UPDATEDATE DATE
UPDATEUSER VARCHAR2(50 CHAR)
configuration_xml column storing xml data and need to update a line in xml data
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<idcConfiguration>
<aboutToExpireReminderEnabled>false</aboutToExpireReminderEnabled>
<aboutToExpireReminderInterval>5</aboutToExpireReminderInterval>
<allowAutoClaim>true</allowAutoClaim>
<allowDelegation>true</allowDelegation>
<allowFinalReview>false</allowFinalReview>
<allowInteractiveXls>false</allowInteractiveXls>
<automaticDeprovisioningEnabled>false</automaticDeprovisioningEnabled> >>> now i need to change the value from false to true
<skipRoleOwnerStep1>false</skipRoleOwnerStep1>
<thirdReminderEnabled>false</thirdReminderEnabled>
<thirdReminderInterval>3</thirdReminderInterval>
<updateCertifierEmailNotificationEnabled>false</updateCertifierEmailNotificationEnabled>
<viewSiemUserActivity>false</viewSiemUserActivity>
</idcConfiguration>
please let me know the best way to do update ?
Thank you so much