• Database Administrators
• Technical Support Professionals
• Application Developers
• Designer/Developers

Required Prerequisites:

None

Suggested Prerequisites:

None

Course Objectives:

• Implement the methods to use additional data sources on which to base data blocks.
• Include charts, reports, and timers in Forms modules by using wizards and built-ins.
• Understand the concepts behind reusability and procedures to reuse components, objects, and code.
• Implement the new Oracle Server error handling features accessible to Form Builder.

Additional Data Sources

• Identify the types of data sources used for performing database operations on data blocks.
• Base a data block on a FROM clause query by using the Property Palette.
• Write the code to base a data block on a stored procedure that returns a Ref cursor.
• Write the code to base a data block on a stored procedure that returns a table of records.
• Identify the properties of a data block based on a stored procedure.
• Identify the performance implications specific to database calls using a particular data access mechanism.
• Identify the guidelines to base a data block on a stored procedure.
• Identify the restrictions on performing database operations on data source objects.

Charts, Reports and Timers: Integration in Forms

• Create a chart item in a Form module by using the Chart Wizard.
• Identify the type of a chart on the basis of its appearance.
• Identify the properties of Chart Items.
• Create a report object based on a data block in a Form module by using the Report Wizard.
• Identify the properties of Report Object.
• 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.

Reusing Components, Objects and Code

• Identify the benefits of reusing objects and code.
• Create a Property class with properties by using the Object Navigator.
• Create a Property Class by using the Property Palette.
• Set the properties of an object by using a named Property class.
• Create a populated Object Group by using the Object Navigator.
• Copy an object in a Form Builder application.
• Identify the features of subclassed objects.
• Reuse an object by using subclassing.

New Features in Form Builder

• Identify the order of preference for the location of PL/SQL code.
• Identify the features of error messages caused by failed Form Builder calls to the Oracle Server.
• Match the predefined error messages with the DML declarative constraint violations that generate them.
• 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.
• Complete the code to dynamically perform database operations by using FORMS_DDL.

Please check with your Education Representative to determine the appropriate follow up course.

No related Interactive Courseware is currently available.