Oracle & VFP ODBC Error (VFP Memo field)

[volfreak]

All,

I have a FoxPro 2.6a application that a client wants to be in Oracle tables. Changing the application to directly access the Oracle tables is too large of a job and will take too long for this client's needs so it is set up to mirror the FoxPro data daily in to the Oracle tables. I have written a routine to update the Oracle tables by using VFP and remote views. However, I have run in to a problem on tables (.DBF files) that contain a Memo field.

I have used VARCHAR2 (width of 4000), BLOB and CLOB field types in Oracle and when trying to update the remote view of the Oracle table, if the table has a Memo field, I get the following error:

CONNECTIVITY ERROR:<[Oracle][ODBC][Ora]ORA-24801: illegal
parameter value in OCI lob function.

Can anyone provide suggestions on how to get the data in to the Oracle tables from the Memo field? What field type in Oracle should I use? Running the program with all fields except the Memo fields works just fine. But once I add in the memo field to be included in the update, I get the error.

Thanks in advance for any and all help.