Problem Inserting a PDF in Oracle DB

Avatar

04-07-2008

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..

Replies

Avatar

Avatar
Coach
Level 10
Jasmin_Charbonn
Level 10

Likes

149 likes

Total Posts

2,154 posts

Correct reply

97 solutions
Top badges earned
Coach
Give Back 1000
Give back 900
Give Back 800
Give back 600
View profile

Avatar
Coach
Level 10
Jasmin_Charbonn
Level 10

Likes

149 likes

Total Posts

2,154 posts

Correct reply

97 solutions
Top badges earned
Coach
Give Back 1000
Give back 900
Give Back 800
Give back 600
View profile
Jasmin_Charbonn
Level 10

04-07-2008

Avatar

15-07-2008

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.