Oracle Forms

Course Introduction

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

Session 1: INTRODUCTION

• What is Oracle Forms?
• Oracle Form Builder Components
• Application Code Partitioning
• Exercise: Preparing to Work with Oracle Forms

Session 2: GETTING STARTED

• Creating an Oracle Form
• Running an Oracle Form
• The Runtime Interface
• Performing Queries
• Updating Records
• Exercise: Creating and Running an Oracle Form

Session 3: THE FORM BUILDER INTERFACE

• The Main Menu
• The Object Navigator
• Basic Components of a Form
• Property Palettes
• The PL/SQL Editor
• The Layout Editor
• Exercise: Using Oracle Form Builder Tools

Session 4: BUILDING A FORM

• Basic Steps in Development
• Creating a Data Block
• Customising the Layout
• Setting Properties For Data Blocks and Items
• Adding Trigger Code
• Running the Oracle Form
• Exercise: Building a Simple Oracle Form
• Exercise: Building a Master-Detail Oracle Form

Session 5: TRIGGERS

• What is Navigation?
• Navigational Triggers
• Item and Block Validation
• Commit Form Triggers
• Query Triggers
• Trigger Types and Scope
• Trigger Code
• Global, System and Bind Variables
• Handling Errors
• Exercise: Implementing Navigational Triggers
• Exercise: Implementing Commit-time Triggers
• Exercise: Implementing Query Triggers

Session 6: INTRODUCING STANDARD BUILT-INS

• Unrestricted Built-in Procedures and Functions
• Restricted Built-in Procedures
• Calling Built-ins
• Getting and Setting Properties at Runtime
• Using Internal Object IDs
• Error Handling
• Exercises: Enhancing Oracle Form Applications using Built-ins

Session 7: MORE INTERFACE OBJECTS

• Basic Controls - Text and Display Items
• Iconic Push-buttons
• Check Boxes and Radio Groups
• List Items
• Image Items
• Alerts
• Editors
• Record Groups and LOVs
• Hierarchical Trees
• Exercises: Creating Additional Interface Items

Session 8: PROGRAM UNITS

• Oracle Form Module Program Units
• PL/SQL Libraries
• Database Procedures
• Exercise: Using PL/SQL Libraries
• Exercise: Using Database Procedures

Session 9: CANVASES AND WINDOWS

• Content Canvases
• Stacked Canvases
• Toolbar Canvases
• Tab Canvases
• Handling Windows
• Exercise: Generating Canvases and Toolbars
• Exercise: Handling Multi-Window Applications

Session 10: RE-USING COMPONENTS

• Visual Attributes
• Property Classes
• Copying Objects
• Subclassing
• Object Groups
• Object Libraries
• Exercise: Creating and Using a Property Class
• Exercise: Creating and Using an Object Library

Session 11: 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 12: DEBUG FACILITIES

• Running in Debug Mode
• Creating Break Points
• Monitoring Application Data

Session 13: 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 14: 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 15: 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 16: 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