pdf file stored as BLOB data type on Oracle

[BALAJI_JAY]

I store PDF file as BLOB data type on Oracle. There are cases where I get multiple records from the database, that means I get multiple PDF files. They have to be merged and displayed on the web page. I tried CFContent which can display only one PDF file at a time but not more than one, whereas cfdocument is having problem converting binary data to string. I am kind of stuck.

Can you anybody please help me out? Please let me know if you have any questions or this does not make sense to you.
Thank you in advance.

[Newsgroup_User]

BALAJI_JAY wrote:
> Can you anybody please help me out? Please let me know if you have any
> questions or this does not make sense to you.

if by "merge" you mean 3 pdf into 1 pdf, try cfpdf (if on cf8) or see this
thread if cf version less than 8:

http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=7&threadid=1114635&mess...

[BALAJI_JAY]

I have a select statement for BLOB column from the database - for example SELECT BLOB_DOC FROM DOCUMENTS WHERE DOC_SEQ_NO = (DOCNUMBER). This query returns 5 rows. Actually I get 5 BLOB records (each one of them is a PDF file). I wanted to combine the BLOB documents to display one big pdf file on the web page. I get the error of converting Binary data to string when I use cfdocument or cfpdf.
Can you please provide some suggestions? I use CF8. Thank you in advance.

[Newsgroup_User]

BALAJI_JAY wrote:
> Can you please provide some suggestions? I use CF8. Thank you in advance.

lets start simple, write out the BLOBs as pdf files (cffile) & see if those can
be merged.

[BALAJI_JAY]

Thanks it works fine. I did write using CFFILE and then I merged them using cfpdf. Finally, the merged file was passed on to cfcontent type="application/pdf" file="merged.pdf". Thanks again to your help and suggestion.