130 likes | 247 Vues
Join John Krahulec in this comprehensive Lunch and Learn session focused on developing pipeline applications with TURBOEnterprise. This tutorial delves into the four main parts of the RRRD architecture: Render, Retrieve, Receive, and DML. You will gain insight into utilizing a pre-configured "cloud" environment with TURBOTestTrack, Oracle HTTP Server, and Oracle XE Database. Learn essential development techniques using your preferred PL/SQL editor. Equip yourself with the knowledge and tools necessary to successfully navigate the development process.
E N D
Hands on Development Tutorial Presented By: John Krahulec August 4, 2010 Lunch and Learn
Agenda (The “Road” to Success) • Develop Pipeline app TURBOEnterprise Overview Demo Pipeline application 4 Main Parts – RRRD
A pre-configured “cloud” environment so you can quickly get started developing with TURBO. Here’s what it includes: TURBOTestTrack Oracle HTTP Server Oracle XE Database TURBOEnterprise
TURBOTestTrack Here’s what you’ll need: Your favorite PL/SQL editor (e.g. TOAD) Web Browser Database connection info
4 Main Parts – RRRD (“Road”) Render Retrieve Receive DML
4 Main Parts – RRRD (“Road”) APP_WEB APP_DATA Retrieve Render Table Receive DML
Render Purpose: to render the web page/form Schema Layer: APP_WEB Package: l_[appname] Procedure: p_xxx_form Input Parameters: usually the record id of data to be displayed
Retrieve Purpose: to retrieve data for the rendering page Schema Layer: APP_DATA Package: l_[appname]_DML Function: f_get_xxx Input Parameters: at least record id of data to retrieve
Receive Purpose: to receive data from the web page Schema Layer: APP_WEB Package: l_[appname] Procedure: p_xxx_proc Input Parameters: at least all fields from web page
DML Purpose: to process data from the Receiving proc Schema Layer: APP_DATA Package: l_[appname]_DML Procedure: p_xxx_load Input Parameters: fields required to perform DML into tables
Contact Information John Krahulec 703-889-8499 John.Krahulec@TURBO-Enterprise.com Mark Eddy 703-889-8452 Mark.Eddy@TURBO-Enterprise.com