Forum Stats

  • 3,837,949 Users
  • 2,262,310 Discussions
  • 7,900,436 Comments

Discussions

ORDS returning JSON in PLSQL

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?

Answers