Book Image

Oracle APEX Best Practices

Book Image

Oracle APEX Best Practices

Overview of this book

Have you ever wanted to create real-world database applications? In this book you're not only getting APEX best practices, but will also take into account the total environment of an APEX application and benefit from it."Oracle APEX Best Practices" will guide you through the development of real-world applications. It will give you a broader view of APEX. The various aspects include setting up APEX environment, testing and debugging, security, and getting the best out of SQL and PL/SQL.In six distinct chapters you will learn about different features of Oracle APEX as well as SQL and PL/SQL.Do you maximize the capabilities of Oracle APEX? Do you use all the power that SQL and PL/SQL have to offer? Do you want to learn how to build a secure, fully functional application? Then this is the book you'll need. "Oracle APEX: Best Practices" is where practical development begins!
Table of Contents (14 chapters)
Oracle APEX Best Practices
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Print API


Application Express also has APIs available for printing documents. These APIs are apex_util.download_print_document and apex_util.get_print_document. Both Print APIs have four different signatures, which they allow for programmatically downloading report queries while dynamically associating stored report layouts at runtime, downloading report queries with custom templates stored in your own tables, and generating PDF based on your own custom XML by using your own custom templates.

APEX_UTIL_DOWNLOAD_PRINT_DOCUMENT initiates download of a print document in four ways. Each has slightly different parameters (you can read more about these parameters at http://download.oracle.com/docs/cd/E23903_01/doc/doc.41/e21676/apex_util.htm).

The first option is to use XML-based report data and an RTF- or XSL-FO-based report layout:

APEX_UTIL.DOWNLOAD_PRINT_DOCUMENT (p_file_name IN VARCHAR,p_content_disposition IN VARCHAR,p_report_data IN BLOB,p_report_layout IN CLOB,p_report_layout_type IN VARCHAR2...