Hi wgb, Does overwrite mean replace of existing content with blank/empty or replace it with another blob?.. If the choice is first option then empty_blob would do. If later then a plsql program to read new blob and replace the old blob would be easier. Best regards Sriram kumar -- //www.freelists.org/webpage/oracle-l