Blob versus Server Directory
Date: Mon, 12 May 2003 10:49:31 -0500
Message-ID: <3EBFC28B.2493021E_at_ram.lmtas.lmco.com>
I have a need to have users save files that are associated with
particular records. We are talking about any file types, e.g *.html,
*.doc, *.gif, *.vsd, *.mpp, and many more.
I understand there are a couple ways to do this:
1) actually save the file as part of the record in an Oracle Blob field.
Never done this before. If you have any examples this would be great.
2) for each record, create a directory on a server identified by the
record ( the key id ) and store that file out in that directory server.
Save the name of the file stored on the directory in an Oracle text
field.
Anyone want to comment on which of these methods you think is preferred?
I can do 2), but I have never implemented 1) above.
Mike