>>Does anyone know how to store binary files into a Oracle Long Raw or Long datatype. ... A remote view of an Oracle table with a Long Raw shows up as general field in Visual FoxPro. Attempting to use APPEND GENERAL results in an ODBC error ORA-00997: illegal use of LONG datatype.<<
Change the field property of the remote view from a General field to a memo. then use "APPEND MEMO
FROM (FileName) OVERWRITE" to put the file into Oracle and then Use "COPY memo to (FILENAME)" To get the data back out.
A company I am doing this for told me that the best way to work with long raws is to have a two column table -- a) the primary key and b) the long raw field. and to eliminate any editing -- just deletes and inserts. [I am including attachments, so I have one table that describes the attachment and then a related two column table for the actual long raw].
Kevin
