How to insert long XML string in blob in pl / sql?

Question

I have an XML string that contains more than 5000 characters. I have to store this XML string in Oracle db having blob as the data type, as shown by the toad.

How can it be saved?

Answer 1

try it

insert into tabbleName values(utl_raw.cast_to_raw(varchar2Data));

varchar2 has a size of 4000 as a column and 32767 as a variable.