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 Robert Shankin
Appian Employee
over 11 years ago

What about your requirement necessitates this operation? Why not store the Excel and PDF files in Appian?

As the size of the base64 string increases, you're going to reach a point where it's too large for Oracle to insert into the blob in a single statement. The string would to be "chunked" apart and appended into the blob using a stored procedure.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Robert Shankin
Appian Employee
over 11 years ago

What about your requirement necessitates this operation? Why not store the Excel and PDF files in Appian?

As the size of the base64 string increases, you're going to reach a point where it's too large for Oracle to insert into the blob in a single statement. The string would to be "chunked" apart and appended into the blob using a stored procedure.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data