PL/SQL API
Pre-requisites
APEX 5.0.4 or higher needs to be installed in the database as the PL/SQL API uses some packages that come with APEX e.g. apex_json.
Install in the Database
Go into SQL Plus, SQLcl, SQL Developer or SQL Workshop and make sure following packages exist aop_api24_pkg, aop_plsql24_pkg, the synonyms aop_api_pkg and aop_plsql_pkg. As part of the installation those packages should have been compiled.
How to use
You can call AOP straight from PL/SQL. APEX Office Print comes with two different ways of calling AOP; one package is aop_api_pkg which is also used behind the scenes in the APEX Plug-in and the other one is aop_plsql_pkg. aop_plsql_pkg is especially useful when you just want to do the call to the AOP server component or cloud.
Next to the above two packages we also provide two additional packages that show how to do the pl/sql calls. See the packages aop_sample_pkg and aop_test_pkg.