Hi All, I am trying to insert a Base64 string (of a created doc) into

anagha_abhyankar over 11 years ago

Hi All,

I am trying to insert a Base64 string (of a created doc) into DB using query DB node, the colum type is BLOB in DB, The query is as below:

update rtech.bdm_blob_test set myblob = rtech.base64decodeclobasblob_plsql(base64clobgoeshere)

It is throwing an error on screen as below:

ORA-01461: can bind a LONG value only for insert into a LONG column.

Please suggest what needs to be done....

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 11 years ago

What is the value of the type="" attribute in the xs:element of your field? In the example below it's xs:string

<xs:element name="msg" type="xs:string">
           <xs:annotation>
<xs:appinfo source="appian.jpa">
@Column(columnDefinition="BLOB")
</xs:appinfo>
</xs:annotation>
           </xs:element>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 11 years ago

What is the value of the type="" attribute in the xs:element of your field? In the example below it's xs:string

<xs:element name="msg" type="xs:string">
           <xs:annotation>
<xs:appinfo source="appian.jpa">
@Column(columnDefinition="BLOB")
</xs:appinfo>
</xs:annotation>
           </xs:element>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data