Usage

Example for the usage of PL/PDF:

• When developing internet/intranet applications with MOD_PLSQL, Oracle does not provide a reporting tool, PL/PDF can provide this functionality
• Similarly, HTML DB is a development tool that does not have a tool to prepare reports and printouts. Because HTML DB is based on MOD_PLSQL, therefore PL/PDF can be used to produce the necessary documents
• Oracle Portal systems provide the possibility of developing in PL/SQL, so PL/PDF can be adopted to provide documents
• PL/PDF stores the PDF document in the database, so it can be used in conjunction with systems that can read from an Oracle database, but are not written in PL/SQL
• During implementation of an Oracle Warehouse Builder (OWB) project, it is always a requirement to provide technical documentation on the objects stored in Warehouse Builder (mappings, dimensions, facts etc.). Unfortunately, OWB does not provide Design Repository Reports that would produce the documentation in a well formatted manner. PL/PDF will document OWB objects and will store the resulting documentation in the Oracle database, where it can be accessed without the use of web servers
• Oracle Discoverer also does not provide an End User Layer metadata document generator. PL/PDF can be adopted for this purpose
• Oracle schemas or database can be also documented using PL/PDF, thus providing a useful technical or user documentation
• Customized catalogs or guides can be prepared according to user/customer specification for a specific product. The content and arrangement of information can be user specific
• Customized financial statements: an employee or manager can set his/her preferences and the statements are produced accordingly
• The Oracle RDBMS is capable of executing procedures as scheduled jobs. Using this capability, according to preset preferences, documents can be produced and published on an internet/intranet site or can be e-mailed to a person or group