Oracle Forms - Part I

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: INTRODUCTION TO CALLING OTHER FORMS

• Built-in Procedures
• Methods for Calling other Oracle Forms
• Exercise: Calling one Oracle Form from Another

Session 12: DEBUG FACILITIES

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

Session 13: ORACLE FORMS SERVICES

• Overview
• Oracle Forms Compatibility Issues
• Architecture and Components of the Oracle Forms Client

Session 14: GETTING STARTED

• Preparation
• Default Deployment
• Using runform.htm for Testing
• Generating URLs
• Default Configuration Files
• Exercise: Test an Oracle Form using runform.htm
• Exercise: Create a URL to Deploy and Test an Oracle Form

Session 15: CONFIGURING FORMS SERVICES

• The formsweb.cfg Configuration File
• System and Runform Parameters
• Forms Applet and HTML Tag Parameters
• Archive Parameters
• Creating Application-specific Configurations
• Renaming and Relocating formsweb.cfg
• Customising the base HTML Files
• Exercise: Create Application-specific Configurations
• Exercise: Create a Custom Configuration File

Session 16: DEALING WITH ICONS AND IMAGES

• Boilerplate and HTML Images
• Forms Icons and Images
• Images Loaded at Runtime
• Other Images
• SplashScreen, Background and Logo Images
• Using jar Files
• Exercise: Deploy a Variety of Icons and Images
• Exercise: Create and Use a jar File

Session 17: OTHER CONFIGURATION ISSUES

• Icons in Form Builder
• The Environment File default.env
• The Registry File registry.dat
• Font Mappings
• The web.xml and forms90.conf Config Files
• Notes on Configuring for SSO
• JInitiator
• Exercise: Configure registry.dat and default.env
• Exercise: Configure web.xml and forms90.conf

Session 18: PERFORMANCE CONSIDERATIONS

• Built-in Optimisation Features
• Using and Customising JInitiator
• Improving Performance
• Exercise: Implement Features to improve Performance