book

Oracle Developer Forms Techniques

Name: Oracle Developer Forms Techniques
Author: Bulusu Lakshman
ISBN: 0672318466

by Bulusu Lakshman

February 2000

Intermediate to advanced

264 pages

5h 5m

English

Pearson

Read now

Unlock full access

Copyright
Dedication
About the Author
Acknowledgments
Tell Us What You Think!
Introduction
What's NewThe Structure of This BookIntended AudienceConventions Used in This Book
1. GUI Development
Standard Toolbar ImplementationDisplaying Menu-Level ToolbarsDisplaying a Form-Level or Window-Level ToolbarSimulating the ToolTip Feature in Forms 4.5Toolbar TipsThe Toolbar Template FormCommon Form ToolbarsWindow-Specific Toolbars for Modal WindowsFloating ToolbarsFloating Toolbar Pop-Up MenusTimers and Displaying a ClockUsing REPEAT TimersSpecial Tips for List ItemsPopulating List Items DynamicallyPopulating a List Item with Date and Number ValuesAdding Items to the Beginning of a ListAdding Items in the Middle and to the End of a ListSimulating a Drill-Down and Drill-Up LOV Using T-ListsSimulating the Find Feature of List of ValuesOrdering by Foreign Key Items in FormsQuerying by Nonbase Table ItemsTips for Standard GUI Practices and Forms DevelopmentSummary
2. Advanced GUI Development: Developing Beyond GUI
Playing with RelationsSuppressing Master-Detail BehaviorToggling Between Immediate and Deferred CoordinationObtaining Query Count Without EXECUTE-ing a QueryUsing Form and Global VariablesTips for Working with VariablesBase TablesChanging the Base Table of a Block DynamicallyBasing a Block on a FROM Clause QUERYDML Operations on a Block Based on a FROM Clause QueryBasing a Block on a Stored ProcedureTips for Basing Blocks on Stored ProceduresSpecifying Ad Hoc Query Criteria in Case of Blocks Based on Stored ProceduresThe Power of Record GroupsChanging a Record Group DynamicallyAdding to the Beginning of a Record GroupAdding in the Middle or at the End of a Record GroupMultiple SelectionIntermediate Sorting Using Record GroupsCreating a Customized Sign-on FormAvoiding Confusion Between DO_KEY and the Corresponding KEY- TriggerWindow Management in FormsClosing a Window with the × IconResizing, Repositioning, and Closing Any WindowSummary
3. Multi-form Applications
Myths About the Form Filename, Form Module Name, and Form IDPassing Data from the Called Form to the Calling FormForm Management in an OPEN_FORM ConfigurationProper Navigation Between FormsProper COMMITProper Exiting SequenceSimulating a CLOSE ALL FORMSTracking QUERY_ONLY ModeSpecial Tips for Working with Multi-form ApplicationsSummary
4. Advanced Forms Programming
The Work-around for PL/SQL 2.x Limitations in Forms 4.5Populating a PL/SQL Table from a BlockThe Success or Failure of TABLE_FROM_BLOCKTaking Advantage of PL/SQL 2.x in FormsFile Output from a BlockAn Exclusive Server-Side Commit from FormsIntersession and Interdatabase Communication from FormsSharing a Record Group Across FormsAdditional Tips for Sharing Record GroupsSummary
5. Error-Message Handling
The Basics of Error-Message HandlingError TypeError Severity LevelBuilt-ins, Triggers, System Variables, and ExceptionsHandling ErrorsFORM_SUCCESS and FORM_TRIGGER_FAILURESuppressing Errors Using ON-ERROR and ON-MESSAGE TriggersErrors Raised from the Failure of Forms Built-InsErrors Raised from the Failure of Forms Object PropertiesThe Proper Use of FORM_TRIGGER_FAILUREErrors Raised from Exceptions from Triggers and Program Unit CodeErrors Raised on the Server Side and Propagated to FormsSuppressing Errors Using :SYSTEM.MESSAGE_LEVELDeficiencies in Forms Error-Message HandlingErrors That Cannot Be Tracked by FORM_SUCCESS or FORM_FAILUREThe Inability of the ON-ERROR Trigger to Track Forms ErrorsFORM_SUCCESS or FORM_FAILURE in Nested TriggersForms' Inability to Track OVERALL FORM SUCCESSForms' Inability to Track Whether a Particular Trigger Fired or Which Trigger FiredSummary

6. Object-oriented Methods in Forms
InheritanceEncapsulationObject and Code ReusabilitySubclassingSubclassing and CopyingObject GroupsObject Libraries and Subclassing by Means of Smart ClassesForm LibrariesPolymorphismSummary
7. Intelligence in Forms
Smart Classes and Smart Triggers— How Smart Are They?How Smart Classes Exhibit IntelligenceHow Smart Classes Lack IntelligenceHow Smart Triggers Exhibit IntelligenceHow Smart Triggers Lack IntelligenceDoes Subclassing Exhibit Intelligence?Normal Trigger IntelligenceHow Triggers Exhibit IntelligenceHow Triggers Lack IntelligenceIntelligence with Regard to Form Object PropertiesHow Forms Ignores Object Property Values and Thereby Enforces Smart RulesHow Forms Fails to Be Smart While Using Some Object Property ValuesHow Smart Is Forms in Implementing Query-Only Mode?Other Non-smart Object PropertiesIntelligence with Regard to Form WizardsHow Smart Is the Forms Data Block Wizard?How Smart Is the Forms LOV Wizard?Summary
8. Additional Interesting Techniques
Programmatically Canceling a QueryProgrammatic Equivalent of Cancel QueryValidation, Navigation, and Simulating NavigationVALIDATION, VALIDATION_UNIT, and VALIDATEVALIDATEEnhancing the Function of Exit FormPreventing Validation of WHEN-VALIDATE-ITEM for Control Items During Query TimeWhen to Use WHEN-VALIDATE-RECORD and When to Use WHEN-VALIDATE-ITEMHow Does the Validation Unit Property Influence This Behavior?When to Use the Same Trigger and How to Make It Fire at Multiple LevelsUsing the Same Trigger at Multiple LevelsMaking the Same Trigger Fire at Multiple Levels More Than OnceA Block Level CommitSummary
9. Working with Trees
Creating a Tree ItemOperations on a Tree ItemCaution Regarding Ordering Tree Item DataDynamically Populating a TreeSelection of a NodeDouble-clicking a NodeExpanding a NodeCollapsing a NodeExpanding All NodesCollapsing All NodesFinding a Particular NodePlanting and Growing Trees—Dynamically Adding Nodes Along with Data to an Existing Base TreeAdding a Sub-tree to the Next Node of a Given Node and at the Same LevelAdding a Sub-tree as the First Top-level Node of a Tree (Before the Node at Level 1)Adding Tree Data ElementsAdding a Single Node as the Next Successive Node of a Given Node and at the Same LevelAdding a Single Node as the First Top-level Node of a Tree (Before the First Node at Level 1)Shrinking TreesSummary
10. Oracle 8 and 8i Features in Forms Developer
Techniques for Querying and Updating New Data Sources in Forms Based on ObjectsCRUD on Object Table Based Blocks in FormsCRUD on Object-Type Based Items in Forms (Column Object)A New Look at Relations Using REFSUsing Join Conditions for Forms RelationsUsing REF Items for Forms RelationsBasing a Block on a Stored Procedure Involving Object TablesRecord Groups and LOVs Based on ObjectsThe Effect of Directly Selecting the REF ColumnRecord Groups Based on Object Columns and/or Object-type Based Object TablesDynamically Creating Object Record GroupsPL/SQL8 and 8i in FormsPL/SQL8 and 8i in Forms 6.0PL/SQL Features Common to Oracle 8 and 8iSummary

Content preview from Oracle Developer Forms Techniques

Chapter 10. Oracle 8 and 8i Features in Forms Developer

IN THIS CHAPTER

Programming with objects involves using object tables (entire tables based on a single object type), VARRAYS, nested tables, REF columns, and stored procedures returning one of these object values. Oracle Developer 6.0 onwards has introduced the capability of performing CRUD (Create, Retrieve, Update, Delete) operations on block data sources based on some of these object categories. Also it has the capability of using some features of PL/SQL ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF

Publisher Resources

ISBN: 0672318466Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Oracle Developer Forms Techniques

by Bulusu Lakshman

Chapter 10. Oracle 8 and 8i Features in Forms Developer

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.