O'Reilly logo

Oracle APEX Best Practices by Learco Brizzi, Iloon Ellen-Wolff, Alex Nuijten

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

How to bypass the 32K limit

One issue, which will be addressed in the next version of Application Express, is the 32K limit on report columns. This means that only fairly small images are currently supported when using the technique with report queries or report regions. If the XML data is generated some other way, and the PDF rendering is done using the Print API, the use of larger images would be possible as well.

The 32K limit on report columns can be bypassed by using the Print APIs—apex_util.download_print_document and apex_util.get_print_document. With these APIs, you can generate PDF and other documents through a simple PL/SQL API call. These APIs take care of all the communication with BI Publisher or Apache FOP.

The apex_util.get_print_document ...

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