Reading BLOB data from FCI_ATTACHMENT_BLOB

[Former Member]

Hi,

I need to read some Big Text data from FCI_Attachment table field FILE_DATA. I want to create a query which can display all the Big text data in a column.

I tried using SUBSTR( CAST(FCI_ATTACHMENT_BLOB.FILE_DATA AS VARCHAR(20000)),1)  but it returns binary data.

How do I retrieve the actual text instead of binary information in the query?

Also, what are the options if I want to place each of the bigtext record as separate flat files in a folder location.

Can this be achieved via script?

Appreciate any helpful pointers.

Thanks,

Priyanka

[vikram_shanmugasundaram · Accepted solution]

Hi Priyanka,

Query framework does not support displaying the BLOB data. You can only query the "preview" data which I believe is the first 2000 characters.

You would need to write a script to extract BLOB data and write it to the app server.

Hope this helps.

Regards,

Vikram

[Former Member · Accepted solution]

Thanks for responding Vikram. We realized that during our analysis and developed a function to convert BLOB to string, using this to read in our reports.