Large Data Editor

Golly

Member
I've just downloaded the new version and been looking at the new features. I noticed the Large Data Editor and was keen to try this to view some Word documents we store in CLOBS in a table.

I can view them in RTF format (with just a few control characters), but if I click on the External tab and select to execute with Microsoft Word I generally get a message in Word "doc name or path is not valid" (also the same if I try to open the temporary file directly in Word), and occasionally the odd one will open successfully but with loads of control characters (much harder to read than RTF).

I know that these objects are ok as we have an application to open them up for editing and viewing in Word, so is there a fault here somewhere? Using Oracle 8i (with the NLS charset as WE8ISO8859P1) and Office 2000...
 
I'm not sure if it is technically possible to store an MS Word document in a CLOB column. You should store them in a BLOB column, because they contain binary data. Character data is subject to conversion between client and server.
 
Back
Top