• State Not Answered
  • Replies 27 replies
  • Subscribers 7 subscribers
  • Views 11871 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

How to Define "BLOB" dataType of SQL in Appian CDT

mohammedz
A Score Level 2
Guyz,

I have a table in database with three columns
ID - Number
Document - BLOB
Name - VARCHAR

The Document column is of "BLOB" DataType....
Now I need to create a CDT and Map it to the Table
To do so what should be the dataType in my CDT or XSD Definition

Appreciate ur response....!!!!

OriginalPostID-232170

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 2
    For sending the doc as BLOB i am using insert query. I have tried multiple combination but still I am getting the below error

    java.sql.SQLSyntaxErrorException: ORA-00947: not enough values

    Got to know the error why this is happening as we are passing (?) it is throwing ORA Error

    @stefan
    Any thought like how can we overcome this ....?? Eager to know your thought so that it would be helpful for me to proceed further
Reply
  • 0
    A Score Level 2
    For sending the doc as BLOB i am using insert query. I have tried multiple combination but still I am getting the below error

    java.sql.SQLSyntaxErrorException: ORA-00947: not enough values

    Got to know the error why this is happening as we are passing (?) it is throwing ORA Error

    @stefan
    Any thought like how can we overcome this ....?? Eager to know your thought so that it would be helpful for me to proceed further
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.