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

mohammedz

Certified Associate Developer

over 8 years ago

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....!!!!

Discussion posts and replies are publicly visible

Top Replies

ankitb0003 over 8 years ago +1

I have used the following definition for CLOB, It worked for me. it should be same for BLOB. <xsd:element name="DOCUMENT" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian…

Parents

0 mohammedz
Certified Associate Developer
over 8 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mohammedz
Certified Associate Developer
over 8 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data