oracle - How can I insert a long XML string into a blob in pl/sql? -
i have xml string has more 5000 characters. have store xml string in oracle db having blob data type shown toad.
how can stored?
try
insert tabblename values(utl_raw.cast_to_raw(varchar2data));
varchar2 has size 4000 column , 32767 variable.
Comments
Post a Comment