HOW to display BLOB (.pdf files)

HI ,

I am having a problem with displaying pdf files which stored in the oracle database as BLOBs
i have a table which has a blob column and i save all .pdf , .doc , .xml , .txt files as BLOBs. and i use oracle text to do the content searching and display the results in a web browser. When some one insert a query(to search keyword) , it will search the blob column and display matching documents. when someone click one document i want to display the document.

my idea was when the ,first when some one insert a query ,it will starts a searching and return the document id's, and document names first and when some one select a specific document using document id get the related document. (that is if some one click a .pdf file i want to display the pdf file in the browser.)

i am using JSP and servlet for web client.

can some pls tell me how to  get pdf file out of blob object and diplay it in the browser.

thanx.
sasankadAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
Yes, the question is about how to store it, but there is also some code to display it:

// Now query the uploaded BLOB and display it
  $query = 'SELECT BLOBDATA FROM BTAB WHERE BLOBID = '.MYBLOBID;
 ...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I found this for PHP (STFW):
http://forums.oracle.com/forums/thread.jsp?forum=178&thread=233174&message=&tstart=45&trange=15706898

Hope this gives you already some ideas...
0
 
sasankadAuthor Commented:
HI

angel thanx for ur reply.

but in that site they have shown how to insert pdf file in to BLOB in the database. I have already done that part. The question is displaying it. because i first display the search result based on the keyword (or searching query) and then display the relevant .pdf or .doc after clicking one of those results.

regards.
      sasanka
0
 
sasankadAuthor Commented:
thanx angel III

it helped me a lot...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.