Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
9 subscribers
Views
2679 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
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....
OriginalPostID-106795
OriginalPostID-106795
Discussion posts and replies are publicly visible
0
anagha_abhyankar
over 11 years ago
When I update the DB using Write to DS node, it throws the same error for BLOB when @cloumnDefinition="BLOB" is added into the CDT. However, it works fine for CLOB.
Please help ASAP.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
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
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