Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

This course teaches you how to use Oracle Forms Builder 11g to rapidly build scalable, high-performance applications for the Web. You build a sample Forms application for an order entry system, using a variety of GUI controls, and learn to enhance the appearance and functionality of the basic form by using PL/SQL trigger, JavaBeans, and Pluggable Java Components. You will learn to replace or supplement default transaction processing, use WebUtil to interact with the client machine, and pass values from one form to another. Learn how to validate user input, control navigation, and display meaningful messages to users. Emphasis is placed on designing objects and code for reuse.

Duration: 5 Days

Prerequisites

• Experience with SQL and PL/SQL basics
• Oracle Database 11g: Program with PL/SQL R2
• Experience in advanced SQL & PL/SQL (suggested)
• Oracle Database 11g: Advanced PL/SQL (suggested)

Audience

• Application Developers
• Developers
• Forms Developers
• PL/SQL Developers
• Support Engineers
• Technical Consultants

Learning Objectives

• Create form modules, including components for database interaction and GUI controls
• Display form modules in multiple windows and use a variety of layout styles
• Test form modules in a Web browser
• Debug form modules in a 3-tier environment
• Implement triggers to enhance form functionality
• Reuse objects and code
• Link one form module to another
• Use the Forms Debugger to troubleshoot applications
• Validate user input and display meaningful error messages
• Use WebUtil to interact with client computers

Topics

• Running a Forms Application
• Working in the Forms Builder Environment
• Creating a Basic Form Module
• Creating a Master-Detail Form
• Working Data Blocks and Frames
• Working with Text Items
• Creating LOVs and Editors
• Creating Additional Input Items
• Creating Noninput Items
• Creating Windows and Content Canvases
• Working with Other Canvas Types
• Producing and Debugging Triggers
• Adding Functionality to Items
• Displaying Run-Time Messages and Alerts
• Using Query Triggers
• Validating User Input
• Controlling Navigation
• Overriding or Supplementing Transaction Processing
• Writing Flexible Code
• Sharing Objects and Code
• Using WebUtil to Interact with the Client
• Introducing Multiple Form Applications