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.
// Now query the uploaded BLOB and display it
$query = 'SELECT BLOBDATA FROM BTAB WHERE BLOBID = '.MYBLOBID;
...