Oracle Developer: Including Reuseable Oracle Components

This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources to work with Oracle8 objects and to integrate charts reports and timers in form modules. In addition the course covers the procedures to reuse components objects and code and to modify the relations between two associated blocks. Finally the course provides information on the new features available in Oracle Developer.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

Application developers database administrators designer/developers and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures Functions and Packages (60114); and Oracle PL/SQL: Database Programming (60131). In addition learners should have taken the first five parts of the Oracle Developer series: Oracle Developer: Forms Fundamentals (62211); Oracle Developer: Enhancing the User Interface (62212); Oracle Developer: Writing and Debugging Code (62213); Oracle Developer: Project Builder and Menu Modules (62214); and Oracle Developer: Controlling the User Interface Programmatically (62215).

Objective

• Implement the methods to use additional data sources on which to base data blocks.
• Work with Oracle8 objects in Form Builder.
• Understand the concepts behind reusability and the procedures to reuse components objects and code.
• Modify relations between two associated blocks by using programmatic control.
• Include charts reports and timers in Forms modules by using wizards and builtins.
• Understand the new features provided by Form Builder.

Topics Include

Unit 1: Additional Data Sources

• Identify the types of data sources used for data blocks.
• Base a data block on a FROM clause query.
• Create a data block based on a stored procedure that returns a REF cursor by using the Data Block Wizard.
• Create a data block based on the stored procedure that returns a table of records by using the Data Block Wizard.
• Identify the properties of a data block based on a stored procedure.
• Identify the performance implications of using stored procedures.
• Identify the guidelines to base a data block on a stored procedure.
• Identify the restrictions on performing database operations on data source objects.

Unit 2: Oracle8 Objects in Form Builder

• Identify the Oracle8 objects features.
• Identify how Oracle Developer treats Objects in the Object Navigator.
• Create a data block based on Oracle8 objects by using the Data Wizard.
• Create a data block on a table with a REF column by using the Data Wizard.
• Identify the benefits of using the REF LOVs.
• Create a REF LOV by using the Data Block Wizard.
• Update the REF values by using a REF LOV.

Unit 3: Reusing Components Objects and Code

• Identify the benefits of reusing objects.
• Create a Property class with properties by using the Object Navigator.
• Create a Property Class by using the Property Palette.
• Inherit the properties from a property class into an object.
• Create an object group by using the Object Navigator.
• Copy an object in a Form Builder application by using the Object Navigator.
• Identify the features of a subclassed object.
• Reuse an object by using subclassing.
• Create an object library by using the Object Navigator.
• Populate a Form Builder module with objects from an object library by using the Tools menu.
• Create a SmartClass in Form Builder by using the Object Navigator.
• Sequence the steps to add a Help system to an application.
• Identify the methods to reuse PL/SQL in subprograms.
• Identify the features of PL/SQL libraries.
• Write the code to accept a reference to a bind module variable of local scope in a PL/SQLlibrary subprogram by using parameters.
• Populate a PL/SQL library module with objects from the Program Units node.
• Attach a PL/SQL library to a form module by using the Attach Library dialog box.
• Write a code to reference a library program unit within an attached library in a form module trigger.
• Identify the included reusable components in Form Builder.
• Create a calendar in a form module by using the Calendar object group in the Standard Object Library.
• Write a code to manipulate the calendar at run time by using the Date_LOV.Get_Date built-in in the Calendar.pll attached library.
• Create a picklist in a form module by using the Picklist object group in the Standard Object Library.
• Write a code to display a populated picklist by using Form Builder built-ins.

Unit 4: Data Block Relationships

• Sequence the steps to create a relation.
• Match the Delete Record Behavior properties with their features.
• Identify the block coordination phases in a relation.
• Match the default relation-handling triggers with their properties.
• Match the default relation-handling triggers or procedures to the triggers or procedures that call them.
• Match the coordination properties with their functions.
• Sequence the steps to force a commit per master record.

Unit 5: Charts Reports and Timers: Integrating

• Match the chart types with their descriptions.
• Create a chart item in a Form module by using the Chart Wizard.
• Match the chart item properties with their descriptions.
• Create a report object based on a data block in a form module by using the Report Wizard.
• Identify the properties of Report Objects.
• Identify the built-ins used to programmatically control reports in a form module.
• Write the code to run a report against a local server by using built-ins.
• Write the code to run a report against a remote server by using built-ins.
• Identify the built-ins for timers.
• Write the code to manage timers by using built-ins.
• Identify the features of the When-Timer-Expired trigger.
• Sequence the steps involved in managing expired timers.

Unit 6: Server Features in Form Builder

• Identify the functionality available in Form Builder to handle possible errors.
• Identify the order of preference for the location of PL/SQL code.
• Identify the Oracle8 Server features supported by client side PL/SQL8.
• Complete the code to dynamically perform database operations by using FORMS_DDL.
• Identify the errors that are caused by the failure of implicit DML statements.
• Complete the code for the ON-ERROR trigger to display error information caused by an implicit call to the Oracle Server.
• Complete the code to display error information caused by an explicit call to the Oracle Server.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

CDROM
Web Based Training

• Oracle Developer: Controlling the User Interface Programmatically
• Oracle Developer: Enhancing the User Interface
• Oracle Developer: Forms Fundamentals
• Oracle Developer: Project Builder and Menu Modules
• Oracle Developer: Writing and Debugging Code