Description
This course develops skills in the major tools used for application development in the Oracle Developer 2000 toolset. The tools covered include Oracle Forms 4.5 and Oracle Reports 2.5. This course is designed to provide the critical programming skills required by all developers working with Oracle.

Audience
Application designers, developers and programmers who will be using Oracle Forms 4.5 and Reports 2.5.

Prerequisites
A familiarity with Oracle’s implementation of SQL and PL/SQL to the level provided by Arkoa’s Using Oracle7 SQL*Plus and Using Oracle7 PL/SQL courses is required.

Hardware and Software
Oracle7 with Forms 4.5 and Reports 2.5 properly installed on any platform, with sufficient logins for the number of students and instructor.

Format

• Presentation
  
• Hands-on
  

Objectives
After completing this course, participants should be able to:

• Develop and implement Oracle Forms 4.5 applications
• Create default Forms applications that retrieve, display, change, and store data
• Build a Forms application by customizing a default form
• Use the Object Navigator
• Use menus and libraries
• Debug applications

Introduction to Oracle Forms

• Oracle Forms concepts

Building a Default Form

• Opening, viewing, saving, running, and simple tailoring

Building a More Complex Form

• Using blocks

Further Features

• Defining a list of values
• Formatting data
• Using classes

Triggers

• Event triggers

Push Buttons and Triggers

• Alerts and timers

Windows, Canvasses, and Procedures

• Creating a dialog window
• Creating a canvas

Further Notes on PL/SQL and Forms

• PL/SQL restrictions in Oracle Forms
• Key triggers and built-ins

Block Relations

• Creating and using a relation

Error Handling

• Detecting and raising errors
• ON-ERROR triggers

Multi-User Considerations

• COMMIT processing and triggers; locking

Further Features of Oracle Forms

• Global and system variables
• Message severity levels
• User exits

Menu Modules

• Creating a new menu module and sub-menus
• Integrating the menu into the form

Libraries and Library Modules

• Creating, using, and editing
• Copying and referencing objects

Debugging and Documentation

• Portability, block mode, and validation units

Appendix A: The Example Company and Applications

• Appendix B: SQL*Forms Reference Information