General information
Title:
Storing binary files in Oracle Long/Long Raw datatype
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only