Oracle APEX Blogs - Jaydip Bosamiya - Oracle APEX Consultant

Apex Office Print (AOP) is a great tool for document printing, document conversion and document merging. We have used AOP Converter API to merge pdf documents, and it works great. It was fast to implement and worked very well. We have observed during testing that we are hitting performance issue with large pdf files. I have used following apporach to overcome this. Following is the sample AOP API call where we were getting performance issue: l_blob_return := aop_api_pkg.plsql_call_to_aop(       p_data_type             => 'SQL',       p_data_source           => q'!select       'file1' as "filename",       cursor       (select            '1' as "dummy"        from dual       ) as "data"   from dual!',       p_template_type        ...

I have been using RESTful API to download BLOB content as a file. This is very useful in many places where you want to give your BLOB document as a source to URL. This can be used within Oracle APEX or outside Oracle APEX. Following are the steps to create RESTful web service using Media Resource type to make your BLOB document downloadable. Use following link as a live demo, which will return product image for product_id = 1. https://apex.oracle.com/pls/apex/wstesting/demo/download_file/1 Hope this helps. Jaydip Bosamiya jbosamiya@gmail.com