2 Replies Latest reply on Jul 15, 2008 5:33 AM by (Saritha_Reddy)

    Problem Inserting a PDF in Oracle DB

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