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

How to add dynamic images to a report


For static images it's pretty straightforward. Just place the static images into your RTF layout, using MS Word and BI Publisher Desktop. For dynamic images, well that's a little more complicated.

When talking about dynamic images, what I mean is the images that are stored in BLOB columns in database tables. To include the image in the PDF, you need to take care of the following:

  • The image needs to be included in the generated XML representation of the report data and the RTF report layout needs to include instructions on what to do with the image information stored in the XML data.

  • Before BLOB columns can be included in the XML export, they need to be converted to CLOB by using base64 encoding and the report template needs to reference the image data column by using an XSL-FO expression. So the reports template needs to reference the image data column, using XSL-FO expression.

    Tip

    Keep in mind the 32K limit on report columns.

The next few steps show how...