Try to use Blob field instead of Memo in VFP.

>I'm using a FoxPro 9 front end via Oracle ODBC to Populate an Oracle table.
>The Oracle table has a field with CLOB data type.
>
>
>I'm using SQL passthrough to create a FoxPro cursor. The CLOB is mapped to a FoxPro Memo field.
>
>To populate the memo field, I use the FILETOSTR( DocumentName). Work fine in the FoxPro cursor.
>
>When using the TABLEUPDATE(), only part of the content of the MEMO field update the the CLOB ORACLE field.
>So when I retreive the field back, the document is damaged.
>If I try with plain text, everything works fine
>
>
>1) What is the best way to achieve my goal?
>2) What is the best Oracle data type to use to strore Word document?
>3) Do I need to use CONVERTBINARY(), if yes, how do I reconvert to character?
>4) Anyone with sample code to achieve this?
>
>Any hints would be appreciated.