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

padmanabhanv over 11 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 11 years ago

Rob, The document does get stored in Appian too, but it is business critical to update the same as a BLOB to an oracle db, the rationale being that there are other systems leveraging the same information downstream and they don't want to change that part of the file storage mechanism for now.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 padmanabhanv over 11 years ago

Rob, The document does get stored in Appian too, but it is business critical to update the same as a BLOB to an oracle db, the rationale being that there are other systems leveraging the same information downstream and they don't want to change that part of the file storage mechanism for now.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data