Greg,
I am not too sure if the following is OK in your case, as you're attempting some work at the DB level for enabling Oracle FTS against AR System raw tables ... but just in case... If going through AR System API is an option, you could use ARGetEntryBLOB in C, Util.ARGetEntryBLOB in Java, BMC.ARSystem.Server.GetEntryBLOB in .NET or COM. Using any of these API calls, you'll be able to retrieve the blob data in uncompressed format as a byte buffer. After that you could do whatever you wish (like for example, populating the uncompressed blobs into your DB and indexing them perhaps). Getting the uncompressed data using API is trivially easy, but I am not so sure about what you're set out to do. To me, it sounds more like an RFE for AR System FTS feature to loosely couple its implementation to a specific provider (hummingbird currently) and allow for hooking in other providers in its place if customer's wish to do so. Regards Appajee On 11/22/06, Greg Elphick <[EMAIL PROTECTED] > wrote: > Hi Listers, > > Has anyone figured out what compression method is used to store > attachments as blobs in Oracle yet. I thought I would use Oracle FTS > instead of AR FTS as it wont cost us any extra but it cant create FTS > indexes on the compressed text in the column. > > Thanks in advance > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" > __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
