Does anyone know how to store binary files into a Oracle Long Raw or Long datatype. I would like to be able to store Crystal Reports .rpt files in an Oracle table that can be accessed throughout our WAN without having users attach to a specific server or replicating .rpt files over 15 servers. A remote view of an Oracle table with a Long Raw shows up as general field in VFP. Attempting to use APPEND GENERAL results in an ODBC error ORA-00997: illegal use of LONG datatype. Furthermore, I do not know of a way to programmatically pull out the file once in a general field.

I have tried to use a LONG datatype in Oracle by using FILETOCHR(). Using a VFP table and a memo field I can successfully import and export the Crystal Reports .rpt file by using FILETOCHR() and CHRTOFILE(). However, when updating an Oracle table, the LONG data field is truncated.

Any suggestions would be greatly appreciated.

Thanks,

Greg