Search
  • Bheem

How to Get BLOB content using REST API

Please follow below steps.

Step 1: Select Restful services->ORDS Based REST Services

Step 2: Create Module

Step 3: Enter Module Details

Step4: Create Template

Step5: Enter URI Template details

Step6: Select URI Template created in previous step

Step 7: Create Handler

Step8: Enter Handler Details & Source Query


Output

URL : https://apex.oracle.com/pls/apex/vijubhee/gallery/images/7



Classic Report Query

SELECT
    LISTAGG('<img src="https://apex.oracle.com/pls/apex/vijubhee/gallery/images/'
            || id
            || '">', ' ') WITHIN GROUP(
        ORDER BY
            id
    ) AS images
FROM
    documents1;


Dynamic Gallery Output from above API

Thanks for Reading. Please share & subscribe.

184 views0 comments

Recent Posts

See All

How to create network ACL in oracle database.

when you are calling third party API in oracle using UTL_HTTP then you will face Network access denied by ACL error if ACL is not created. To create ACLfirst login with sys account then run below code