I have been came across requirement for printing nested JSON in one of the application. Using APEX_JSON, there is no straight forward way – I can just print a cursor or ref-cursor to an output as nested JSON. So, I have to write a pl/sql block and manually build JSON output. Purpose of this blog …

Apex Office Print is one of the popular tool for generating documents using Oracle APEX. While using AOP process type plugin, you will commonly see following error message. Error: SyntaxError: Unexpected token % in JSON at position 0 Above error has nothing to do with AOP settings or anything else. Following is simple solution: 1. …