>Come again? I'm not sure what a binary memo is and I'm not sure what part of the process you are referring to? Are you saying that I can convert the binary to memo text, save it to the oracle server and then when I need to download it, convert it back into binary, save as a file and then load it up as an OLE object? I hope so, it sounds like a much better solution.
Sorry, I overlooked the "Oracle" part.
In Visual FoxPro native tables, there are memo, and binary memo, fields. Memos accept variable character length, and are store in a separate file - instead of the DBF, a separate FPT file is used.
A normal memo or character field can be subject to automatic changes, due to codepages. These fields are appropriate for text. A binary memo or character field will not be changed, and is therefore more appropriate for storing binary data.
Although this explanation applies to VFP, perhaps you might do something similar in Oracle: store in a memo field instead of a general field. Or whatever the equivalent in Oracle is called.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
