Using PL/SQL in Forms6i/9i and Reusability Issues
Assumptions and pre-requisites
Delegates have experience in generating Oracle Forms (4.5, 5 or 6) using basic
point and click techniques, and want to learn more about how to customise Forms
with PL/SQL.
Course Outline
Very quick review of PL/SQL
- Block structure
- Variables and datatypes
- SQL and Cursors
Server side Stored Procedures
- Procedures, functions, and packages
- Passing parameters
- Using REF CURSORs
Triggers in Forms
- Predefined triggers
- Writing PL/SQL in triggers
- Debugging code in Forms
- Calculation Formulas
- Exceptions in triggers
Form built-in routines
- Highlighting the most important routines
- How to review documentation
- Referencing form objects
- Dealing with errors
Reusability of PL/SQL
- Named routines in a form
- PL/SQL Libraries
- Using server-side stored procedures
Re-usability in general
- Copying versus Subclassing
- Visual Attributes
- Property Classes
- Object Groups
- The Object Library
- The template form v. the object library
Basing Forms on PL/SQL
- Control blocks and data blocks
- Basing a block on a non-updateable view
- INSTEAD OF triggers on client and/or server
- Basing a block on a PL/SQL procedure returning a REF CURSOR
- Basing a block on a PL/SQL procedure returning a PL/SQL table
- Basing a block on a piece of SQL (a FROM clause)
- Programmatic control of the block source
- DEFAULT-WHERE
- ORDER_BY
- QUERY_DATA_SOURCE_NAME
Passing parameters between forms
- Using GLOBAL variables
- Using parameter lists
- TEXT_PARAMETER
- DATA_PARAMETER
[RETURN TO LIST OF COURSES] |
