Open LOB data ( BLOB, CLOB ) with external editor

Open blob/clob with external editor

For many large objects that are stored in the database it may be necessary to invoke an external viewer or editor.

For example, if a BLOB column contains the contents an Acrobat PDF file (Portable Document File), it will be necessary to invoke the Acrobat Reader.

When invoking the Blob Editor for such content, you will initially be taken to the Hex view page.

After that, you can switch to the External Open page.

external open

Here you can define which program should be executed.

First you will need to define the file extension.

Next you will need to define which program should be executed.

When click Execute button, a temporary file with the editor contents will be saved with that extension.

Then you can view the content in the external program.

Most programs will have registered their file types, and instead of manually defining the extension and program you can simply select it from a list.

First you will need to press the 'List registered file types' button.

After that you can search for the correct file type and double-click on it. For a PDF file this would be the Adobe Acrobat File:

OraLobEditor is a database tool that helps DBA and Database Programmer edit Oracle LOB (BLOB, CLOB) data directly.