Saving content of large CLOBs to disk, bypassing Large Data Editor

[Lars J]

I have got some large CLOBs (containing XML) in my database (35 MB). Instead of opening them in the Large Data Editor, I just want to save them to disk. Is there a simple way of doing this?

 

[Marco Kalter]

Yes and no. Here is a little trick:

The Large Data Editor has an option to invoke an external viewer. You can associate a specific external viewer with a column, so that it is automatically invoked. You could for example use the following "external viewer":

cmd /c copy "%1" c:\temp\large_data_editor.xml

This simply copies the contents of the column ("%1") to c:\temp\large_data_editor.xml. Here is a picture of the definition:

Everytime you press the cell button (...) of the associated column, the contents will be copied to the specified file. You merely need to rename or move it.

 

[Lars J]

Thank you very much. The trick works! But in a future release, perhaps SaveAsFile and LoadFromFile on LOBs would be nice in addition to the Large Data Editor.

 

[Marco Kalter]

Definitely.