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!

Related Content you might be interested in

Current Title:

Small book image
Oracle APEX Best Practices
Nov, 2012 | 298 pages
No titles found
Table of Contents (14 chapters)
Oracle APEX Best Practices
Oracle APEX Best Practices
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Prepare and Build
Prepare and Build
History and background
Installing APEX
Choosing a web server
Creating a second administrator
Database
Creating a workspace
User Interface Defaults
Page Zero
Structure of multiple applications
Creating applications
Summary
2
Leveraging the Database
Leveraging the Database
Instrumentation
Efficient lookup tables
Analytic functions
Aggregate functions
Searching the contents of documents
Summary
3
Printing
Printing
Printing architecture
Installation and configuration of the Apache FOP report server
How to debug or troubleshoot printing issues
How to check if network services are enabled
Creating a report with BI Publisher
How to create a report that can deliver output in different formats
How to add a chart to a report
How to add dynamic images to a report
Print API
How to bypass the 32K limit
Alternatives to use for PDF printing
Plugins
Summary
4
Security
Security
Securing Oracle Application Express for administrators
Virtual Private Database
Security considerations when installing Oracle Application Express
Security considerations for the developer
Summary
5
Debugging and Troubleshooting
Debugging and Troubleshooting
Debugging an APEX page
APEX_APPLICATION.G_DEBUG
APEX and Oracle SQL Developer
Remote debugging
JavaScript console wrapper
Web development tools
Summary
6
Deploy and Maintain
Deploy and Maintain
Package your application, or not?
Deploying the database packages
Deploying the APEX application
Being active and proactive
Summary
Database Cloud Service and APEX 4.2
Database Cloud Service and APEX 4.2
Oracle Public Cloud
Summary
Index
Index

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 API can be called to generate and retrieve the print document as a BLOB in the database for further processing, such as storing the document in tables, and so on.

The apex_util.download_print_document API can be called in an Oracle Application...

Previous Section
End of Section 11
Next Section