1 Reply Latest reply on Mar 18, 2009 9:45 AM by Steve L Walker

    how to store blob object in document variable

      hi,
      I am using Query single row service to retrieve pdf file from database(it is stored as blob in database). How can i store this blob object in a document variable?
      I gave the mapping in "Data Mapping" property of the service. I mapped the column name with a document variable. It gave the following error:

      com.adobe.workflow.datatype.InvalidCoercionException: Cannot coerce object: weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB@832ef of type: weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB to type: com.adobe.idp.Document.

      can anyone help me in this? Can i store the blob object retrieved from database in any other form in my process?

      Thanks.
      kripa