Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: AN INTRODUCTION

• Notes on Course Content
• Preparation
• Exercise:   Creating Basic Oracle Forms Applications

Session 2: MOUSE AND KEY TRIGGERS

• Mouse Triggers
• Cursor Styles
• Key Triggers
• Exercise:   Implementing Mouse and Key Triggers

Session 3: TIMERS

• Use of Timers
• Creating and Handling Timers
• Timer Triggers and Built-ins
• Exercise:   Creating a Clock Timer

Session 4: RECORD GROUPS

• LOVs and Record Groups
• Record Group Types
• Creating Run-time Record Groups
• Built-in Procedures and Functions
• Record Groups and Lists
• Exercise:   Using Run-time Record Groups

Session 5: DATA BLOCK RELATIONSHIPS

• Relation Object Properties
• Creating Relationships Manually
• Procedures and Triggers for Coordination
• Modifying Default Functionality
• Exercise:   Creating and Modifying a Relation Object

Session 6: MULTI-FORM APPLICATIONS

• Calling Other Forms
• The OPEN_FORM Procedure
• The CALL_FORM Procedure
• The NEW_FORM Procedure
• Related Built-ins
• Passing Data between Forms
• Creating Parameters and Parameter Lists
• Exercise:   Calling Oracle Forms and Passing Parameters

Session 7: CREATING CUSTOM MENUS

• Menu Modules, SubMenus and Menu Items
• The Menu Editor
• Menu and Menu Item Properties
• PL/SQL in Menu Modules
• Menu Item Built-ins
• Menu Security
• Menu Parameters
• Popup Menus
• Exercise:   Generating a Custom Menu

Session 8: HANDLING DATABASE OBJECTS

• Object Support and Object Types
• Object Tables
• Column Objects
• Handling REF Columns
• Exercise:   Handling Objects with an Oracle Form

Session 9: USING OTHER DATA SOURCES

• Data Source Types
• Using a FROM Clause Query
• Using Procedures which return REF Cursors
• Using Procedures which return PL/SQL Index-By Tables
• Implementing DML using Packaged Procedures
• Exercise:   Defining and using FROM Clause Query
• Exercise:   Defining and using a Packaged Procedure

Session 10: USING ORACLE DATABASE FEATURES

• Database Functionality
• Handling PL/SQL Code
• Handling Database Server Errors
• Using the FORMS_DDL Package
• DDL Functionality
• Exercise:   Using the FORMS_DDL Package

Session 11: REUSABLE COMPONENTS

• Reusable Component Definition
• Oracle-Supplied Components
• Using Oracle's Calendar Class Component
• Notes on Active X Controls
• JavaBeans and PJCs
• Exercise:   Implementing the Calendar Component
• Exercise:   Implementing Pluggable Java Components

Session 12: INCLUDING CHARTS AND REPORTS

• Including Charts
• Oracle Reports Overview
• Running an Oracle Report
• Integrating Oracle Reports with Oracle Forms
• Viewing an Oracle Report
• Exercise:   Interfacing with an Oracle Report