How to Generate PDF Files Using Oracle PL/SQL
By Jim Campbell
The Oracle PL/SQL language provides you with the programming tools to query and retrieve data. You can also use the Oracle language to generate PDF reports. The Oracle Application Express utility allows you to log in and generate reports based off of the selected data on your Oracle database server. PDF files are read-only documents, so the users who receive these documents are unable to edit and change the data.
Click the Windows "Start" button and select "All Programs." Click "Oracle" in the program groups and select "Application Express." In the opening window, click the report you want to export as a PDF.
Click the "Report" link in the main window. In the opening properties window, click the "Report Attributes" tab. Select each table column you want to export to the PDF file. After you select all the table columns, click the "Print Attributes" tab.
Select "Inline" in the drop-down box labeled "View File As." In the "Output Format" drop-down, select "PDF." Remove the checkmark from "Export for the PHOTO." Click "Recalculate" to estimate the report layout.
Click "Run" to export the data to a PDF. Click "Print" to save the file to your hard drive. A preview displays so you can see a list of your Oracle data.
- Click "Edit" in the preview page to change any settings before exporting to PDF.
Jim Campbell has been a computer engineer for over five years. He excels in hardware repair, computer programming and troubleshooting, and software design. He is currently attending Florida Atlantic University, pursuing a master's degree in computer and electrical engineering and fine-tuning his technical writing abilities.