oracle - XML value cannot convert to BLOB -

when retrieve xml file front-end try put data xml blob column in oracle table. following error;

ora-01465: invalid hex number

front end sending binary object type.

here xml tags contain following details.

<contents>mzevmdcvmjaxna0kms4grmluzcbhihdhesb0bybzdg9wihbvc3riywnrigluifryzwugr3jpzcbpbibdywhydcbpzibby2nvdw50cybnb2r1bguglsbeb25ldqoylibjcybeaxnidxjzzsbgb3jtdwxhihnhbwugyxmgrm9ybxvsyq0kmdyvmdgvmjaxna0kms5dagfuz2ugrgviaxrdcmvkaxqgdg8grgviaxrdcmvkaxrob3rldqoyos8woc8ymde0dqoxllnhbgvzic0gqxv0agvudgljyxrpb24gcmvxdwlyzwqgzm9yig1vcmugb3b0aw9ucw0kmi5iaxn0b3j5ic0gt3b0aw9uihrvihzpzxcgaxrlbsbsaxn0dqozlknhc2huawxsic0gt3b0aw9uihrvihnwzwnpznkgsw4vt3v0dqowmy8wos8ymde0dqoovg8gq2fzacbuawxskq0kms5bzgqgq2xlyxigqnv0dg9ucyb0bybidxr0b25zihn0cmlwic0grg9uzq0kmi5tzwfyy2ggbm90ihdvcmtpbmcncjmurg91ymxlignsawnrigzlyxr1cmugdg8gaw5jcmfzzsbpdgvtcyatiervbmuncjquqwrkienszwfyicygumvtb3zligj1dhrvbib0bybrzxkgcgfkic0grg9uzq0kns5haxzligfuig9wdglvbib0bybjagfuz2ugy29sb3igyw5kigltywdligr5bmftawnhbgx5lg0kni5nywtligrlzmfsdxqgdghyzwugynv0dg9ucybhihjvdyatiervbmuncjcuqxjyyw5nzsbcdxr0b25zdqowos8wos8ymde0dqoxlk1vzglmesbnyxn0zxigvukgyxmgzglzy3vzc2vkdqoylkzpbmfsaxplienhc2ggvglsbcb0bybfrg0kmy5eyxrhifbhz2ugdg8gchvzacbhbmqgchvsbcbkyxrhien1c3rvbwvyl0l0zw0vtgvnywwgvgvuzgvycw0kmtkvmdkvmjaxna0kms4gu3luy2hvbml6zwqgyml0ihrvignozwnrifnhbgvzigfucybtywxlcybszxr1cm5zigjlzm9yzsbpbml0awfsigrhdgegbg9hzcbhbmqgc2hvdybtzxnzywdllg0kmi4gqwrkihbyb2dyzxnzigjhcibhbmqgynv0dg9ucybmb3iguhjvzhvjdcwgq3vzdg9tzxigyw5kifbyb21vdglvbnmgu2vwzxjhdgvses4ncjmuiezpbmfsaxplihnlc3npb24gzm9yigxvz2luic0grg9uzq0kmjivmdkvmjaxna0kms4gsw50zxjmywnligzpbmfsaxphdglvbiatiervbmuncjiuiedldcbtzxnzywdligzvcib1bnn5bmnlzcbkyxrhlibjbnzvawnll1nhbgvzifjldhvybi9wb3vjagvyl0nvdxbvbi9pcgvyyxrvci9dyxnovglsbc9tzxnzaw9usw5mb3jtyxrpb24glsbeb25ldqozlibtzw5kifvuc3luy2vkigrhdgegdg8gc2vydmvylibdcmvhdgugysbzy3jlzw4uifnlcgvyyxrligrhdgegcgfnzsatiervbmuncjizlza5lziwmtqncjeuifzlcmlmesbkb3dubg9hzcbkyxrhic0grg9uzq0kmi4gvmvyawz5igluaxrpywxeyxrhiexvywqgd2l0acbtzxnzywdpbmcncjmuie5ldybvchrpb24gdg8gz2v0ig9wzxjhdg9ycybzzxblcmf0zwx5ic0grg9uzq0knc4gr2v0ihbyb2r1y3rzihnob3vszcbpbmnsdwrlihbyb21vdglvbnmglsbeb25ldqo1libszw1vdmugzgf0ysb1cgxvywqvzg93bmxvywqgdmfsawrhdglvbiatiervbmuncjyuie9wzxj0b3igcgfzc3dvcmqgy2hhbmdlihnob3vszcb3b3jrihdpdgggc2vydmljzs4gcmvtb3zligxvy2fsihbhc3n3b3jkihnhdmuuic0grg9uzq0kmjqvmdyvmjaxna0kms4gu2fszxmgumv0dxjuigrhdgegdxbsb2fkic0grg9uzq0kmi4gtwvzc2fnaw5nihdpdgggc2nyzwvuigzpbmv0dw5pbmcncjmuifhtbcbnzw5lcmf0aw9uic0grg9uzq0kmjuvmdkvmjaxna0kms4grgvmaw5lihbybybjbgfzcybiyxnlig9uihrozsbzywxlcybncmlkliatiervbmuncjiuiefzew5jihrvifn5bmmgbwv0ag9kigluigxvz2luic0grg9uzq0kmy4gwg1sihzlcmlmawnhdglvbibmb3igzgf0ysb1cgxvywqncji5lza5lziwmtqncjeuia0kmi4gsw52b2ljzsbjbnnlcnqgdg8gbg9jywwgzgf0ywjhc2usia0kmdevmtavmjaxna0kms4gu2vuzcbvcgvyyxrvcibzzxnzaw9uigjlzm9yzsbkyxrhihvwbg9hzcatiervbmuncjiuieltcgxlbwvudcbwcmv2awxhz2vzdqozlibszxr1cm4gbwv0ag9kcybpbnrlcmzhy2ugbw9kawzpy2f0aw9udqoxmc8wos8xna0kms4gu2vzc2lvbiwgu2vzc2lvbibezxrhawwsienhc2ggvglsbcwgu2fszxmsifnhbgvzifjldhvybg0kmi4gugfzd29yzcbjyw4gymugy2hhbmdlzcbvbmx5ihrozsb1c2vyiglzig9ubgluzs4gugfzc3dvcmqgd2lsbcbizsb1cgrhdgvkig9uy2ugdghlihvwbg9hzcbjb25maxjtzwqgynkgdghlihnlcnzpy2uudqozlibdyxnoihrpbgwgbmvlzhmgdg8gchjvdmlkzsbhigxpc3qgb2ygdxnlcnmgd2hvighhcybhbibhy3rpdmugy2fzahrpbgwudqoxms8wos8ymde0dqoxlibdyxnodglsbcbjc3n1zq0kmi4gu2hvccbdbg9zzsbdyxnovglsbhmgbxvzdcbizsbjbg9zzwquiefsbcb1c2vycybtdxn0igjligxvz2dlzcbvdxqsigfsbcbkyxrhig11c3qgymugc3luy2vklg0kmy4grgf0ysbvcgxvywqncjquifjlbw92zsbpqkpdrvqgd3jhchblcibpbibwyxnzd29yzcbjagfuz2ugwe1mdqo1libdagvjayb0zxjtaw5hbcbvcgvycmf0b3jzigluc2vydcbpbibkyxrhigrvd25sb2fkdqo2libtzxqgdg8gmtagd2hlbib1bmfibgugdg8gy3jlyxrlihnlc3npb24ncjcuihnhbwugz29lcyb0bybhchbyb3zhba0kmtuvmdkvmjaxna0kms4gu2hvdybkaxnjdw50ihbyzwnlbnrhz2ugb24gqmvmb3jlieludm9py2ugkervy2tldcbeaxnjb3vudcwgt3zlcnjpzgugrglzy291bnqpdqoylibjbnzvawnlihjldhvybibhbw91bnqvsw52b2ljzsbeyxrldqoymi8xmc8ymde0dqoxlibeb2nrzxqgaglzdg9yesbwcmludgluzyatiervbmuncjiuigrvy2tldcbzy2fuihnlyxjjacb3axrob3v0ihnlyxjjacbidxr0b24glsbeb25ldqozlibyzxr1cm4gyw1vdw50ig5vdcbjywxjdwxhdgluzybhznrlcibzy2fuic0grg9uzq0knc4gy2xlyxigdgv4dgjvecbhznrlcibzy2fuic0grg9uzq0kdqo=</contents> 

this query. try retrieve.

select content   xmltable ('/object/commonfileupload/commonfileuploadfilelist/commonfileuploadfile'                passing (select xmlcol bizzxe_v2_sch.b)                columns content   blob  path 'contents') t 

this example target table

create table "test"    ( `"content" blob`    ) 

oracle throws error ora-01465: invalid hex number when attempt put string blob field. need convert binary format first. can using utl_raw.cast_to_raw() function. find out more.

however, have here string representation of binary encoding. there's no point in storing blob. should store clob; when front-end queries contents return string is, , let them decode it.

---

for record, here code used extract contents element xmltype column , store blob:

declare     vc varchar2(32767);     lb blob; begin      select t.content     vc     b,          xmltable ('/object/commonfileupload/commonfileuploadfilelist/commonfileuploadfile'                    passing b.xmlcol                    columns content   clob  path 'contents') t;     lb := utl_raw.cast_to_raw(vc);    insert tgt values (lb); end; / 

and here outcome:

sql> select * tgt;  bcol ---------------------------------------------------------------------------------------------------------------------------------------------------------------- 4d7a45764d4463764d6a41784e41304b4d533467526d6c755a43426849486468655342306279427a64473977494842766333526959574e7249476c75494652795a57556752334a705a43427062694244  sql> 

not useful.