Hi,
I have a JSON response already in a CLOB column in DB and need to send this out as raw response to the ORDS GET handler.
For this have used the source type as Media Resource and just written following select.
SELECT 'application/json', js_column
FROM js_table;
The above works fine. however i need to do a post action (do a DML on the js_table - update flags, audit etc.). How can i achieve the same with a PLSQL block?