CREATE TABLE EXCPTN_VARCHAR
(
    EXCPTN_ID     NUMBER(38)     NOT NULL,
    EXCPTN_RECRD  VARCHAR2(4000)     NULL
);

CREATE TABLE EXCPTN_XML
(
    EXCPTN_ID     NUMBER(38)     NOT NULL,
    EXCPTN_RECRD  XMLTYPE     NULL
);

 insert into EXCPTN_XML
 select  e.EXCPTN_ID,
         e.EXCPTN_RECRD
 from EXCPTN_VARCHAR e;

ORA-31011: XML parsing failed
 *Cause:   XML parser returned an error while trying to parse the document.
 *Action:  Check if the document to be parsed is valid.

create table test_183 (col_1 xmltype);

insert into test_183 values ('<start><tag_1>a</tag_1><tag_2>b</tag_2></start>');

insert into test_183 values ('<start><tag_1>a</tag_1><tag_2>b</start>');

<RECORD  UNQ_SOI_ID = "2241199" PRICE_SRC_BATCH_ID = "-1" AS_OF_DT = "2010-04-07 00:00:00" PRTY_NBR = " 2" CREATE_DT = "2010-04-07 13:51:28" />

SQL> select xmltype('<RECORD  UNQ_SOI_ID = "2241199" PRICE_SRC_BATCH_ID = "-1" AS_OF_DT = "2010-04-07 00:00:00" PRTY_NBR = " 2" CREATE_DT = "2010-04-07 13:51:28" />') from dual;
XMLTYPE('<RECORDUNQ_SOI_ID="2241199"PRICE_SRC_BATCH_ID="-1"AS_OF_DT="2010-04-0700:00:00"PRTY_NBR="2"CREATE_DT="2010-04-0
------------------------------------------------------------------------------------------------------------------------
<RECORD  UNQ_SOI_ID = "2241199" PRICE_SRC_BATCH_ID = "-1" AS_OF_DT = "2010-04-07 00:00:00" PRTY_NBR = " 2" CREATE_DT = "
2010-04-07 13:51:28" />

1 row selected.

CREATE TABLE EXCPTN_VARCHAR(EXCPTN_ID     NUMBER(38)     NOT NULL
                           ,EXCPTN_RECRD  VARCHAR2(4000));

CREATE TABLE EXCPTN_XML    (EXCPTN_ID     NUMBER(38)     NOT NULL
                           ,EXCPTN_RECRD  XMLTYPE);
                           
insert into excptn_varchar values (1,'<RECORD  UNQ_SOI_ID = "2241199" PRICE_SRC_BATCH_ID = "-1" AS_OF_DT = "2010-04-07 00:00:00" PRTY_NBR = " 2" CREATE_DT = "2010-04-07 13:51:28" />');   

 insert into EXCPTN_XML
 select  e.EXCPTN_ID,
         e.EXCPTN_RECRD
 from EXCPTN_VARCHAR e;
 
 commit;

Select XMLType('<RECORD COL1="EQUITY545734&<^*^>"/>') 
From dual;

Select XMLType(replace('<RECORD COL1="EQUITY545734&<^*^>"/>','&','&amp;'))
From dual;

regexp_replace('<RECORD COL1="EQUITY545734&<^*<^>"/>','(".*)<(.*")','\1&gt\2')

SELECT   
regexp_replace(replace('<RECORD COL1="&>>>"/>','&','&amp;'),'(".*)>(.*")','\1&gt;\2')  AS COL1
FROM dual;

with src as (select '<RECORD COL1="&>>>"/>' col_1 from dual)
select regexp_substr(col_1,'^[^"]*') ||
       (replace(replace(replace(regexp_substr(col_1,'".*"'),'&','&amp;'),'<','&lt;'),'>','&gt;') ||
       regexp_substr(col_1,'[^"]*$'))
from src;

<RECORD ASK_PRICE = "40""1" CREATE_USR_ID = "asibm" /> 

select dbms_xmlgen.convert('<RECORD ASK_PRICE = "40""1" CREATE_USR_ID = "asibm" />',1) recrd
from dual;

<RECORD ASK_PRICE = "40&qout;&qout;"1" CREATE_USR_ID = "asibm" />