Just happen to refer to this thread.
You can use DBMS_LOB.SUBSTR to query repeatedly 4000 characters out of the field and concat them after finish.
DBMS_LOB.SUBSTR(FieldName, 2000, ?)
? is replace with a counter, increase by 2000 each time.