Building Applications with Oracle Developer and Rdb

Oracle Forms, part of the Oracle Developer package, supports quick development of sophisticated client/server applications. Forms is closely tied to Oracle’s Oracle7, Oracle8, and Oracle Rdb database products, but can be used with any ODBC-compliant database.

This seminar provides an introduction to the basics of Forms as well as numerous advanced topics that leverage the power of Rdb. In addition there are significant sections, based on JCC practical experience, that are not available in the standard training at either the introductory or advanced levels. These practical pointers, together with the source code examples, will help you build robust applications for solutions to real business problems by suggesting when to accept Oracle Developer defaults, when and how to modify the defaults, and when to add procedural components.

The developers and presenters of this seminar have long term experience with software development. You will be able to share the results of experience with the products as well as a wide variety of application successes and significant experience in software research.

The seminar is designed to impart the JCC experience with client/server applications and Oracle Developer. Students will have hands-on use of the product to access Oracle Rdb.

Basics

· Client/server & multi-tier architectures

· Overview of creating a form with Oracle Developer interspersed with labs

· A User View - What Oracle Developer has done for you

                    · Installation and Relationship of the software components

 Managing It All

· Software Engineering challenges

· Managing your production database

· Examining the queries that Forms presents to the database

· Standards

                     · Object libraries

 Upward Compatibility

· Defaults versus customization

· Version conversion

· Issues for a smooth path

                     · Documentation and HELP

 

Programming Issues

                    · PL/SQL

· Built-in procedures

· Transaction control

· Calling stored procedures and Rdb functions

                    · Leveraging Rdb’s system tables

More on Forms

· Lists

· Scroll bars

· Types of canvases and their interaction

· Types of items - buttons, text, checkboxes, etc.

· LoV and Validation

· Blocks and block relationships

· Forms triggers

· Toolbars

· Menus

· More on standards

                    · Debugging

 Navigation

· Event-driven programming

· Using and/or suppressing Oracle Developer’s helpful procedures

                    · Multi-form applications

 Linking to Other Software

· Icons

· Images

· APIs

· Web delivery

                    · Other Oracle products

 Oracle Reports

· Creating

· Using

· Calling Rdb stored procedures/functions

· Transaction control

                    · Integration with Forms

 Webforms

· Performance issues

                    · Forms6i CGI

Seminar Presenters:

Jeffrey S. Haidet, Software Engineer

Cheryl P. Jalbert, Senior Consultant

Keith W. Hare, Senior Consultant

Thomas H. Musson, Senior Consultant

Copyright 1993-2002, JCC Consulting, Inc.  JCC and the JCC logo are trademarks of JCC Consulting, Inc.  Oracle Developer, Oracle7, Oracle8 and Oracle Rdb are trademarks of the Oracle Corporation.  Oracle is a registered trademark of Oracle Corporation.