Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

What variable can be used a BLOB for Oracle ?

Avatar

Level 7
I would like to back up all PDF forms on our Oracle Server. In the Call Stored Procedure module I would like to pass the PDF as BLOB in the database.



What variable can I use ?



Aditya
1 Reply

Avatar

Level 10
You can use the parametrized query option and have your SQL stmt be something like:



Insert into table_name values(?,?);



and then in the grid section add an entry for each '?' and select the right type in the drop down. Blob will be in the list. Put the variable that contains the value under the value column. You can put you PDF in document variables.



Jasmin