We have a business need to store Excel/Pdf files as BLOB in an oracle database a

padmanabhanv over 10 years ago

We have a business need to store Excel/Pdf files as BLOB in an oracle database and the ability to search and retrieve the same from Appian later on. Tried mapping the document to a base64 encoded string and then storing to the db, but when the doc size is large NULL gets stored. Unable to achieve this by using the query rule- the error does not make sense, but I guess it is because of the BLOB data type.
Is there a straightforward plugin or function to achieve this or should we resort to writing a plugin? Please advise....

Discussion posts and replies are publicly visible

Parents

0 padmanabhanv over 10 years ago

On having a single source of truth - business wants it to be the file stored in oracle via Appian; reason being that there are other end systems which would look up the file from the same database for reporting/reference.
We may end up convincing business to store the doc in Appian alone, but wanted to rule out technical complications on achieving the same and hence the question. Thanks for the guidance. Appreciate it
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 padmanabhanv over 10 years ago

On having a single source of truth - business wants it to be the file stored in oracle via Appian; reason being that there are other end systems which would look up the file from the same database for reporting/reference.
We may end up convincing business to store the doc in Appian alone, but wanted to rule out technical complications on achieving the same and hence the question. Thanks for the guidance. Appreciate it
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data