Transcript www.turbo-enterprise.com

Hands on Development Tutorial
Presented By:
John Krahulec
August 4, 2010
Lunch and Learn
Agenda
TURBO Enterprise Overview
Demo Pipeline application
4 Main Parts – RRRD
Develop Pipeline app
(The “Road” to Success)
Architecture
Virtual n-Tier Architecture
TURBO TestTrack
A pre-configured “cloud” environment so you can quickly get started
developing with TURBO. Here’s what it includes:
Oracle HTTP Server
Oracle XE Database
TURBO Enterprise
TURBO TestTrack
Here’s what you’ll need:
Your favorite PL/SQL editor (e.g. TOAD)
Web Browser
Database connection info
4 Main Parts – RRRD (“Road”)
1.
Render
2.
Retrieve
3.
Receive
4.
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
Mark Eddy
703-889-8452
[email protected]
[email protected]