Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CLOB to BLOB conversion...

SmithJohn45Nov 2 2021 — edited Nov 2 2021

hi all,
currently working at apex.oracle.com
want to convert clob to blob because after Unload data in .xml file thru Apex, it implicitly converted blob 2 clob. i don't know about the character set / encoding of blob to clob (base64 or any other), how i can get back those image / blob data.
found some functions while searching for the solution and there are different, as it is converted to clob by Apex itself, seniors should help here.
is there any possibility Oracle Apex implicitly handle this task while Load Data -just ask for actual data type which is now clob after Unload-
regards.

Comments
Post Details
Added on Nov 2 2021
9 comments
6,375 views