Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Problem Inserting a PDF in Oracle DB

Avatar

Not applicable
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..
2 Replies

Avatar

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