Declarative CLOB support for Execute PL/SQL Code is finally here!
The typical usecase is submitting and retrieving values larger than 4000 characters in size. You can specify a Page Item whose value will be submitted to the server, and made available to you as
apex_application.g_clob_01. Same goes for retrieving a CLOB. Provide a Page Item, and the CLOB under
apex_application.g_clob_01 at the end of the execution will be loaded into it.
APEX_JSON API to create or consume a JSON Object in the backend, and transport it easily with this plugin.