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

Yup I followed the same and used the below expression. Its not working. I am not able to save the process model only

=('INSERT INTO "BPMBUSINESS"."CABCBLOBTESTZUBAIR" (DOCBLOB) VALUES (ac!doc))')

Looks like to many parenthesis. Have you tried this: ='INSERT INTO "BPMBUSINESS"."CABCBLOBTESTZUBAIR" (DOCBLOB) VALUES (ac!doc)'

Yup i have tried this too but seems to be not working

@Ankit

I have published the CDT and DataStore
When i try fetching the table data using a QueryRule I am not getting data
Getting the below Error


There was an error testing the rule:

Expression evaluation error in rule 'blob_getdata' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [CABCBLOBCDTDT23013], query: [BLOB_getData], order by: [[]], filters:[(ID = TypedValue[it=1,v=5])])

Any idea how to fetch data ??

The documentation states to include the question mark. Have you tried this?

@stefan
Yup I added the ? .. but when I try to save expression is giving error like invalid character is der like that

I deployed the plugin tried to provide some SQL text to it. Try something like this

="INSERT INTO ""BPMBUSINESS"".""CABCBLOBTESTZUBAIR"" (DOCBLOB) VALUES (?)"

I did not test whether it works or not, but this should get you started.

Thanks stefan...!!! Looks to be the text which posted worked for Receiving BLOB into Appian
Let me check it for sending..!!!

You are very welcome :-)

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