Book description
Oracle Developer Forms Techniques describes the concepts and techniques needed to build Web-enabled applications with Forms. The book covers advanced topics in great detail, including understanding and overcoming error handling limitations in Forms, such as errors which cannot be tracked through normal FORM_SUCCESS or FORM_FAILURE, ordering by items based on FK look-ups, obtaining Query Count without actually executing a query, and performing an exclusive server-side commit from Forms. The book also covers object-oriented methods in Forms, and Intelligence in Forms. Code segments are provided to help developers implement these techniques, thus easing application development time and effort.
Table of contents
- Copyright
- About the Author
- Acknowledgments
- Tell Us What You Think!
- Introduction
- 1. GUI Development
- 2. Advanced GUI Development: Developing Beyond GUI
- 3. Multi-form Applications
-
4. Advanced Forms Programming
- The Work-around for PL/SQL 2.x Limitations in Forms 4.5
- Populating a PL/SQL Table from a Block
- Taking Advantage of PL/SQL 2.x in Forms
- File Output from a Block
- An Exclusive Server-Side Commit from Forms
- Intersession and Interdatabase Communication from Forms
- Sharing a Record Group Across Forms
- Summary
-
5. Error-Message Handling
- The Basics of Error-Message Handling
-
Handling Errors
- FORM_SUCCESS and FORM_TRIGGER_FAILURE
- Suppressing Errors Using ON-ERROR and ON-MESSAGE Triggers
- Errors Raised from the Failure of Forms Built-Ins
- Errors Raised from the Failure of Forms Object Properties
- The Proper Use of FORM_TRIGGER_FAILURE
- Errors Raised from Exceptions from Triggers and Program Unit Code
- Errors Raised on the Server Side and Propagated to Forms
- Suppressing Errors Using :SYSTEM.MESSAGE_LEVEL
-
Deficiencies in Forms Error-Message Handling
- Errors That Cannot Be Tracked by FORM_SUCCESS or FORM_FAILURE
- The Inability of the ON-ERROR Trigger to Track Forms Errors
- FORM_SUCCESS or FORM_FAILURE in Nested Triggers
- Forms' Inability to Track OVERALL FORM SUCCESS
- Forms' Inability to Track Whether a Particular Trigger Fired or Which Trigger Fired
- Summary
- 6. Object-oriented Methods in Forms
- 7. Intelligence in Forms
-
8. Additional Interesting Techniques
- Programmatically Canceling a Query
- Programmatic Equivalent of Cancel Query
- Validation, Navigation, and Simulating Navigation
- Enhancing the Function of Exit Form
- Preventing Validation of WHEN-VALIDATE-ITEM for Control Items During Query Time
- When to Use WHEN-VALIDATE-RECORD and When to Use WHEN-VALIDATE-ITEM
- When to Use the Same Trigger and How to Make It Fire at Multiple Levels
- A Block Level Commit
- Summary
-
9. Working with Trees
- Creating a Tree Item
- Operations on a Tree Item
- Planting and Growing Trees—Dynamically Adding Nodes Along with Data to an Existing Base Tree
- Shrinking Trees
- Summary
- 10. Oracle 8 and 8i Features in Forms Developer
Product information
- Title: Oracle Developer Forms Techniques
- Author(s):
- Release date: February 2000
- Publisher(s): Pearson
- ISBN: 0672318466
You might also like
book
Oracle Advanced PL/SQL Developer Professional Guide
Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination with this book …
book
Oracle Fusion Developer Guide
Master Oracle Fusion Middleware Successfully design rich enterprise web applications using the detailed information in this …
book
Advanced Oracle PL/SQL Developer's Guide - Second Edition
Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle …
book
Oracle in a Nutshell
Introduced a quarter-century ago, the Oracle database remains the leading enterprise relational database management system (RDBMS) …