Oracle Developer Forms Techniques

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

IN THIS CHAPTER

• Techniques for Querying and Updating New Data Sources in Forms Based on Objects

• A New Look at Relations Using REFS

• Basing a Block on a Stored Procedure Involving Object Tables

• Record Groups and LOVs Based on Objects

• PL/SQL8 and 8i in Forms

• Summary

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 ...