130 likes | 215 Views
Hands on Development Tutorial. Presented By: John Krahulec. August 4, 2010 Lunch and Learn. Agenda. (The “Road” to Success). Develop Pipeline app. TURB O Enterprise Overview Demo Pipeline application 4 Main Parts – RRRD. Architecture. Virtual n - Tier Architecture.
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