Highlighted

What variable can be used a BLOB for Oracle ?

Aditya_S_

02-03-2009

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

Replies

Highlighted

Jasmin_Charbonn

02-03-2009

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