I remember readng that BLOBs can be stored externally (with reference to
the BLOB file stored in tables instead).
Does anyone have any experience doing this ? I have a few questions:
1).what are the things to watch out for (apart from obvious ones like
'file not found' type errors).
2). How may a stored proc be written to fetch the BLOB data ? (An
example would be very helpful)
3). How are errors handled in the stored proc that fetches the BLOB
data? (again an example would be very helpful)