O'Reilly logo

Oracle APEX 4.2 Reporting by Vishal Pathak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

APEX reporting using fop and Cocoon

Report printing using the fop package and Cocoon are one of the standard ways of report printing in APEX. So let's see how it's done.

We first have to create an ACL to enable external network access in the Oracle database. Use the following code snippet for this:

SQL> exec DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('apex_users.xml','APEX Users','APEX_040200', TRUE, 'connect');
SQL> exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('apex_users.xml','*');
SQL> commit;

Do not forget to add commit at the end.

Once ACL has been set, we have to deploy fop.war on Weblogic. fop.war can be found in <Directory in which apex_4.1.1_en.zip is unzipped>\apex\utilities\fop.

Note

APEX Listener 2.x has fop tightly integrated in it. So, you don't have ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required