Oracle Multiple Form Applications

Document Sample
Oracle Multiple Form Applications Powered By Docstoc
					                                                                                                                                                             Course Length
                                           Oracle Forms Developer 10g: Build Internet                                                                               5 Days
                                                      Applications (ekit)                                                                                    TE1959_20060426

    Course Description: In this course, interface build, test and deploy Internet applications with with user input items such as
                                         you will                                                   Oracle Forms. Working in a
                        graphical user            (GUI) environment, you learn how to build forms
   check boxes, list items, and radio groups. You will also display Form elements in multiple windows and customize data access
   by creating event-related triggers.

    Who Should Attend: Forms Developers and Support Engineers will benefit from taking this course.

                                    Students should have taken Oracle Database 10g: Program with PL/SQL or have equivalent
    Prerequisites:                  experience.

    Benefits of Attendance: Upon completion of this course, students will be able to:
   • Create form modules, including components for database                              • Create form modules, including components for database
     interaction and GUI controls                                                          interaction and GUI controls
   • Display form modules in multiple windows and use a variety of                       • Display form modules in multiple windows and use a variety of
     layout styles                                                                         layout styles
   • Test form modules in a Web browser                                                  • Test form modules in a Web browser
   • Debug form modules in a 3-tier environment                                          • Debug form modules in a 3-tier environment
   • Implement triggers                                                                  • Implement triggers
   • Reuse objects and code                                                              • Reuse objects and code
   • Link one form module to another                                                     • Link one form module to another
    Course Outline:
   Introducing Oracle Forms Developer and                                                                          Controlling Validation Using Triggers
   Forms Services                                           Producing Triggers                                     Performing Client-Side Validation with PJCs
   Grid Computing                                           Grouping Triggers into Categories                      Tracking Validation Status
   Oracle 10g Products                                      Defining Trigger Components: Type, Code, and Scope     Using Built-ins to Control When Validation Occurs
   Oracle Application Server Architecture                   Specifying Execution Hierarchy
   Oracle Forms Services Architecture                       Using the PL/SQL Editor                                Navigation
   Benefits and Components of Oracle Developer Suite        Using the Database Trigger Editor                      Navigation Overview
   Running a Forms Developer Application                    Writing Trigger Code                                   Understanding Internal Navigation
   Working in the Forms Developer Environment               Using Variables and Built-ins                          Using Object Properties to Control Navigation
                                                            Using the When-Button-Pressed and When-Window-Closed   Writing Navigation Triggers: When-New--Instance, Pre- and
   Creating Forms Modules                                     Triggers                                               Post- Triggers
   Creating a Basic Forms Module                                                                                   The Navigation Trap
   Creating a Master-Detail Forms Module                    Debugging Triggers                                     Using Navigation Built-Ins in Triggers
   Modifying the Data Block                                 The Debugging Process
   Modifying the Layout                                     The Debug Console                                      Transaction Processing
                                                            Setting Breakpoints                                    The Commit Sequence of Events
   Working with Data Blocks and Frames                      Debugging Tips                                         Characteristics and Common Uses of Commit Triggers
   Using the Property Palette                               Running a Form in Debug Mode                           Testing the Results of Trigger DML
   Managing Object Properties                               Stepping through Code                                  DML Statements Issued during Commit Processing
   Creating and Using Visual Attributes                                                                            Overriding Default Transaction Processing
   Controlling the Behavior and Appearance of Data Blocks   Adding Functionality to Items                          Running against Data Sources Other Than Oracle
   Controlling Frame Properties                             Coding Item Interaction Triggers                       Getting and Setting the Commit Status
   Creating Control Blocks                                  Defining Functionality for Check Boxes                 Implementing Array DML
   Deleting Data Blocks                                     Changing List Items at Run Time
                                                            Displaying LOVs from Buttons                           Writing Flexible Code
   Working with Input Items                                 Populating Image Items                                 What is Flexible Code?
   Creating Text Items                                      Populating and Displaying Hierarchical Trees           Using System Variables for Flexible Coding
   Controlling the Behavior and Appearance of Text Items    Interacting with JavaBeans                             Using Built-in Subprograms for Flexible Coding
   Creating LOVs                                                                                                   Referencing Objects by Internal ID
   Defining Editors                                         Run-Time Messages and Alerts                           Referencing Items Indirectly
   Creating Check Boxes                                     Built-Ins and Handling Errors
   Creating List Items                                      Controlling System Messages                            Sharing Objects and Code
   Creating Radio Groups                                    The FORM_TRIGGER_FAILURE Exception                     Benefits of Reusable Objects and Code
                                                            Using Triggers to Intercept System Messages            Working with Property Classes
   Working with Non input Items                             Creating and Controlling Alerts                        Working with Object Groups
   Creating a Display Item                                  Handling Server Errors                                 Copying and Subclassing Objects and Code
   Creating an Image Item                                                                                          Working with Object Libraries
   Creating a Push Button                                   Query Triggers                                         Working with SmartClasses
   Creating a Calculated Item                               Handling Server Errors                                 Reusing PL/SQL
   Creating a Hierarchical Tree Item                        SELECT Statements Issued During Query Processing       Working with PL/SQL Libraries
   Creating a Bean Area Item                                WHERE and ORDER BY clauses and the
                                                              ONETIME_WHERE property                               Using WebUtil to Interact with the Client
   Creating Windows and Canvases                            Writing Query Triggers                                 Benefits of WebUtil
   Overview of Windows and Canvases                         Query Array Processing                                 Integrating WebUtil into a Form
   Displaying a Form Module in Multiple Windows             Coding Triggers for Enter-Query Mode                   Interacting with the Client
   Creating a New Window                                    Overriding Default Query Processing
   Displaying a Form Module on Multiple Layouts             Obtaining Query Information at Run Time                Introducing Multiple Form Applications
   Creating a New Content Canvas                                                                                   Multiple Form Applications Overview
   Creating a Stacked Canvas                                Validation                                             Starting Another Form Module
   Creating a Toolbar                                       Validation Process                                     Defining Multiple Form Functionality
   Creating a Tab Canvas                                    Controlling Validation Using Properties                Sharing Data among Modules                                                                                          Phone: 410-290-8383 / Fax: 410-290-9427

Shared By:
Description: Oracle Multiple Form Applications document sample