I'm using an API to generate a PDF using APEX_WEB_SERVICE.MAKE_REST_REQUEST. The response is a stream of the binary data. I've attempted to convert that to a blob since make_rest_request only returns clobs. The printed response looks something like this:
%PDF-1.4
%äüöß
2 0 obj
<</Length 3 0 R/Filter/FlateDecode>>
stream
x�Խͮ#Irn;ϧก*E��� �H�~ � ....
When I convert the clob to a blob and save it in a table, the pdf opens with no content, just a blank rendering.
Is there a way around this. I am on Oracle Cloud Schema Service, so I do not have access to a local drive or any of the custom pdf generation packages generally found in APEX. Is there a tool we can use in pl/sql or Javascript or even a Browser Plugin we can pass the streamed binary data from the clob so that we can render the PDF for printing. We would prefer not to save the PDF's in our database tables if at all possible.