Jon Dixon Hi Jon, So I guess issue with APEX only where i see the unsupported data type error. When i tried using sqlplus it worked and gave me the blob value. Is there anyway to convert or change this blob value to see actual file name?

yes i used _b at the end apex_web_service.make_rest_request_b

Jon Dixon But when I run getlength it gives me correct result, only issue with last statement to get actual file, it give me [unsupported data type], looks like something related to blob.

it says i am new user can not submit a link when i use screenshot or even use the sql commands here, not sure :) But basically I used same command from blog get file and getting below error.. File_BLOB [unsupported data type]

Hi Jon, I am getting "unsupported data type" error when running last sql statement to get actual file. May I know wat else I have to do.