oracle8.1.6
begin
:1 := ttl__create_file(:package_id, :caller_id, :upload_file, :ticket_id, :mime_type, :file_extension);
end;
update cr_revisions
set content_length = :tmp_size,
content = empty_blob()
where revision_id = :revision_id
returning content into :1