1 Reply Latest reply on Aug 9, 2017 4:08 PM by Carlos Cortez

    Error while inserting task payload


      Hi Experts,


      I use JDev


      In BPM process I call web service using Service notation, this web service return base64Binary (will return tiff file in a base64Binary format), So, in human task payload I defined attribute of type base64Binary to receive the webservice output as:


      <messageAttribute name="attachmentFileBinary" attributeType="SIMPLE_TYPE" type="xsd:base64Binary"  updatable="false" external="false"/>


      From human task association I map webserive base64Binary output to my defined attribute as shown:



      But when the process entered to this human task I got this exception:


      exception.description: Error while inserting task payload attachmentFileBinary for task cdc5b1f3-e339-44aa-9b94-5764ae1f3650.

      exception.fix: Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Services.



      Caused by: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column


      Anyone has any idea about this?


      It is urgent issue so please help.