how to generate files from Oracle ECM database
We are storing invoice (Accounts payable) attachments in our ECM database. Data is stored in form of BLOB. Our requirement is to generate the files from the BLOB data and send it to users. The BLOB data is mostly in xml tags, such as <IdcteDocument>, etc. How can we decode these XML tags to generate the files, which are usually in PDF or DOCX format? Is there any API oracle provides to decode this data?
Text based attachments (.txt files) are stored as-is and we are able to decode them.
Thanks,
Saikat