Problem Inserting a PDF in Oracle DB

[#1]

Hi,

I want to insert a PDF in the DB.The column Type is 'blob'.

I storing a pdf in a variable 'outputDoc'of type 'document' and using it as a

parameter in the query.But ,when i execute the process,it gives 'missing expression' exception.

I could succesfully log the pdf using a variable logger.Following is the query I am using.

INSERT INTO TB_TEMPLATE_FULFILLMENT

(PDF_DOCUMENT,PRINT)

VALUES({$ /process_data/@outputDoc $}).



Let me know where I am going wrong..

[Jasmin_Charbonn]

See post http://www.adobeforums.com/webx/.3c056048/1



Jasmin

[#3]

Hi Jasmin,

Thanks for the reply.But my problem is different from "http://www.adobeforums.com/webx/.3c056048/1 ".

When we use RenderPDFForm the OutputPDF can be stored and sent as URL in the response.But this is a unique cached URL i.e. when i click on the same URL sometime later.I cannot view the PDF.

I want to retrieve the PDF from the DB and send it to user as http URL .whenever the user clicks it the PDF has to retrieved .



Hopw you understand the problem.

Can we write servlet code in adobe 'execute script'or anywhere for solving the problem.