Sorted:

Tag: DBMS_LOB

Convert Oracle BLOB to String: Methods & Code

Read Oracle BLOB: Step-by-Step Guide

Fix PL/SQL CLOB Export Issues

Export BLOB Data to File in PL/SQL: Complete Guide