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

    Error while inserting task payload

    3438884

      Hi Experts,

       

      I use JDev 12.2.1.2.0

       

      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.

      ORABPEL-30280

       

      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.

       

      Thanks