ODTUG University: Introduction to Oracle Forms
John Jeunnette Prairie Systems Group, Limited Denver, Colorado johnjeunnette@PrairieSystemsGroup.com
Agenda
Introduction to Forms
Forms Runtime Environment Forms Programming
Form Components Wizards Debugger
Questions/Comments/References
Forms Runtime Environment
Client/server vs Webforms vs Webserver Applications
Client: A personal computer Server: A computer hosting the RDBMS (Windows, Unix, VMS) Middle Tier: A computer running the Forms Server and a web server (Apache or IIS). Web Server: Oracle HTTP Server (Apache) Web Server Form: Dynamic HTML generated by a PL/SQL package (HTML DB) Webform: Oracle Developer Form operating in a browser (native JVM or Jinitiator) JVM: Java Virtual Machine
Forms Runtime Environment
Selection Criteria (personal opinion)
Client/Server or Webforms: controlled environment, rich feature set, traditional application (small user population, high-volume usage). (Forms 9i does not support Client/Server deployment.) Web Server Forms: uncontrolled or public access, query only, large user population, integration with other web-based applications (large, occasional user population).
Forms Runtime Environment
Form Processing
Insert/update mode Enter Query mode
Form Navagation
Function Keys Menus Toolbars
Forms Programming
Components
Form Blocks Items Canvases Windows Attached Libraries Relations Non-Base table blocks
Forms Programming
Components, continued
More Triggers Visual Attributes Alerts Record Groups List of Values (LOV)
Forms Collaborative Development
Reference Forms Object Libraries Program Units and PL/SQL Libraries Templates Standards Designer
References
Oracle Developer Advanced Forms and Reports, by Peter Koletzke and Paul Dorsey, Oracle Press Oracle Forms Developer Form Builder Reference, Available on Metalink: Top Tech Docs->Internet Developer Tools->Oracle Forms->Documentation->Form Builder Reference Oracle Forms Developer and Oracle Reports Developer Guidelines for Building Applications Available on Metalink: Top Tech Docs->Internet Developer Tools>Oracle Forms->Documentation->Guidelines for Building Applications
References
Oracle Reports Developer Release 6i Reference Manual, Available on Metalink: Top Tech Docs->Internet Developer Tools->Oracle Reports->Documentation>Oracle Reports Developer Release 6i Reference Manual Oracle Reports Developer Release 6i Building Reports, Available on Metalink: Top Tech Docs->Internet Developer Tools->Oracle Reports->Documentation>Oracle Reports Developer Release 6i Building Reports Oracle Reports Developer Release 6i Publishing Reports. Available on Metalink: Top Tech Docs->Internet Developer Tools->Oracle Reports->Documentation>Oracle Reports Developer Release 6i Publishing Reports
Demo Data Model
ED_DIAGRAMS has people on diagram ED_PEOPLE has images for person ED_PEOPLE_IMAGES has images for person ED_IMAGES
Form Components - Navigator
Block Wizard
Block/Canvas
Detail Block
Contact
John Jeunnette Principal Consultant Prairie Systems Group, Limited Denver, Colorado JohnJeunnette@PrairieSystemsGroup.com
