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
40 Algorithms Every Programmer Should Know
Learn algorithms for solving classic computer science problems with this concise guide covering everything from fundamental …
book
Head First Design Patterns, 2nd Edition
You know you don’t want to reinvent the wheel, so you look to design patterns—the lessons …
book
Fundamentals of Software Architecture
Salary surveys worldwide regularly place software architect in the top 10 best jobs, yet no real …
book
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
A practical step-by-step guide to develop end-to-end extensions to Oracle E-Business Suite Release 12, with detailed …