Hello @Awes Khan
Thanks for the ask and welcome to Microsoft Q&A.
If the value of the blob is in an Oracle table and just want to copy that value to an azure blob storage or ADLS , I think you can use the copy activity and use Oracle as the sink and ADLS as source. You may need a query to pull the blob data on the Oracle side.
Please do read more about the same here : https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle?tabs=data-factory
Thanks
Himanshu