SQL Navigator 5.5.4 use to have the ability to query and then save LOB data to text files. After installing Nav 6, it seems that it cannot export LOB data to text files anymore.
1. Run a query to return blob data
2. Right click | Export in data grid and export data to txt file.
3. Open created file and it only list rows that note BLOB. There is no specific data.
This is a problem for any export format chosen. No specific blob data is exported, just the word BLOB.
Waiting for fix in a future version of SQL Navigator for Oracle.
May install an older versions of Navigator on the same computer as the newer Navigator 6.