Has anyone handled BLOB/image types in process workflow. I have a scenario where I extract the data(blob) from database and return the same as an xml output to the caller. Do i have to handle the blob return type specially while trying to embed in the xml? I know we have to convert the blob to a binary stream. Has anyone done it before ?
for .e.g my xml doesn't reflect the real value when retrieved from the database.
Blobs are usually stored in XML in some sort of encoded format, usually Base64.
We have a component for base64 encoding and decoding. I'm not sure off the top of my head whether our SQL component handles blob types in the database. If you'd like to verify, please email support-at-avoka.com, and they'll get you an answer...
Thanks for the update, I did try the option and it always returned an empty xml indicating that it was unable to convert it to a base64 format.
I am just trying to understand how to use the base64 encoding on the returned blob object from an underlying sql query. Is there anyway we can do it just on the blob object alone and not on every field ?