Forum Stats

  • 3,750,407 Users
  • 2,250,174 Discussions
  • 7,866,970 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