Toad hangs during export of blobs using the Export Blobs option (data grid | right click | export blob).
I choose to export xml data (datatype blob) into a local directory, and choose to "Export to files named for the value in this column", specifying a column of datatype varchar2(200). The actual strings are about 13 characters long. If I choose to export with sequential numbered file names instead, it exports all rows without problem.
Toad export a few hundred rows then hangs, no errors are given, and I have to use task manager to kill Toad. In some cases it exports about 111 rows, others 791 rows, sometimes 706 rows... it can vary, and it does not seem to stop at any specific row/data. The only thing so far that is consistent is that it will hang and only when using Export Blob with the option "Export to files named for the value in this column".
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center