Description
This course teaches Oracle Forms 4.5 from the Oracle Developer 2000 toolset. This course is designed to establish 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.

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 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
• Add complex triggers to forms
• Use menus and libraries
• Debug applications

Introduction to Oracle Forms

• What is Oracle Forms?
• Oracle Forms concepts

Building a Default Form

• Opening a new form
• The form’s properties
• The New block
• Viewing, saving, and running the form
• Default validation

Building a More Complex Form

• Creating the first block and adding the second block
• Testing the form
• Tailoring items

Further Features

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

Triggers

• Event and block-level triggers
• Trigger contents and scope

Push Buttons and Triggers

• Creating a control block
• Creating a push button
• The WHEN-BUTTON-PRESSED trigger
• Alerts and timers
  

Windows, Canvasses, and Procedures

• Creating a dialog window
• Creating a canvas
• Creating functions and procedures

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

Multi-User Considerations

• COMMIT processing and triggers; locking

Further Features of Oracle Forms

• Global and system variables, message severity levels

Menu Modules

• Creating menu items and sub-menus

Libraries and Library Modules

• Creating and using a library
• Editing a library function
• Copying and referencing objects

Debugging and Documenting

• Portability, block mode, and validation units
• The command line interface