Just saw this in nsoracle/BUGS:
<blockquote>Known Bugs
1. The cleanup after errors after stream_write_lob is very heavy-handed, and
should be fixed to use a better cleanup after interrupting a multipart LOB get.
</blockquote>
Which seems to be relevant for this case