Databases Reference
In-Depth Information
Process Types
Each different process type has a different use depending on the requirement. The types and their uses are as follows:
•
PL/SQL
: General use for utilizing database PL/SQL logic
•
Reset Pagination
: Resets pagination for a report
•
Session State
: Clears session state values; also referred to as cache
•
Data Manipulation
: Built-in processes for reading from and writing to the database
•
Web Services
: Submits a request to a web service provider
•
Form Pagination
: Most often used in master-detail forms
•
Send Email
: Declarative interface to easily send e-mail
•
Close Popup Window
: Supports pop-up window handling
•
Run On Demand Process
: Calls an application-level on-demand process
•
Plug-ins
: Processes functionality provided by plug-ins
Processes in the Help Desk Application
The details behind processes can be very complex. In order to provide an adequate example, let's include a simple
process in the Help Desk application: a requirement that the application keep track of the last time a record was
modified. You can do this by updating a Last Updated date on the record every time it's saved. There's more than one
way to accomplish this task. Here you do it with a process.
First, you need to add the
LAST_UPDATED
field to the
TICKETS
table. To do this you use the SQL Workshop again:
1.
From the
SQL Workshop
drop-down menu, choose
Object Browser
, as shown
in Figure
8-28
.
Figure 8-28.
Navigating to the SQL Workshop Object Browser
2.
Select the
TICKETS
table from the list of objects at left.
3.
Click the
Add Column
button above the table definition, as shown in Figure
8-29
.