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 anagha_abhyankar over 11 years ago

My xsd has below definition:

<xsd:element name="spoa_doc" type="xsd:string" nillable="true">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Column(name="SPOA_DOC",columnDefinition="CLOB")
</xsd:appinfo>
</xsd:annotation>
</xsd:element>

I just tried to change the type tag as mentioned by you above, but it throws error while importing the CDT. I did not change the complete element tag with xs.

Just wondering, why does it not work for BLOB as it works for CLOB? And is anything special needed for updating the data through Datastore or Query DB node in BLOB column, can't relate to the error as in my post.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 anagha_abhyankar over 11 years ago

My xsd has below definition:

<xsd:element name="spoa_doc" type="xsd:string" nillable="true">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Column(name="SPOA_DOC",columnDefinition="CLOB")
</xsd:appinfo>
</xsd:annotation>
</xsd:element>

I just tried to change the type tag as mentioned by you above, but it throws error while importing the CDT. I did not change the complete element tag with xs.

Just wondering, why does it not work for BLOB as it works for CLOB? And is anything special needed for updating the data through Datastore or Query DB node in BLOB column, can't relate to the error as in my post.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data