I use JDev 126.96.36.199.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.
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.
If you are just calling the web service then you should not get any ORA error. Seems you are inserting other data, maybe through a BPEL then ensure the datatypes are defined well:
Until you fix that problem then you won't see if the data association is correct.