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.
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?