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.
What's more, if that data is not meant to be visible, there is no need to use an extra hidden Page Item. You can simply load data from and into global JavaScript variables. Furthermore, one can use the APEX_JSON
API to create or consume a JSON Object in the backend, and transport it easily with this plugin.