Cover | Table of Contents | Colophon
action attribute), extracting the DAD name and the name of the procedure to execute, which is found in the resource name section of the URL. The gateway also extracts any parameters that might have been passed as part of the request. If the request was made with a URL, the parameters are stored in the query string. If the request was made with a form, the parameters are stored in the form's named data entry fields.
action attributes in an HTML form. If the virtual path maps to a CGI directory, the CGI interface is used. If it maps to a cartridge, the WRB method is used. Figure 4.1 shows the relationship between these components.
action attributes in an HTML form. If the virtual path maps to a CGI directory, the CGI interface is used. If it maps to a cartridge, the WRB method is used. Figure 4.1 shows the relationship between these components.
/* and */. Here's an
example:/* || The following procedure unconditionally deletes all || rows from the customer's table. */ PROCEDURE delete_all_customers is ...
CREATE OR REPLACE PROCEDURE delete_all_customers
IS
BEGIN
-- The delete statement blows away all customers
DELETE
FROM customers;
COMMIT; -- Confirm changes
END;
name
datatype(size) DEFAULT default_value;
:=
operator. In this case, the syntax is:|
Tool
|
Web Site
|
|---|---|
|
CAST Workbench
|
http://www.castsoftware.com
|
|
FROG (Funky Resource for Oracle Gorillas)
|
http://www.507pm.com/pcs
|
|
Oracle Procedure Builder
|
http://www.oracle.com
|
|
PLEdit
|
http://www.benthicsoftware.com
|
|
PL/Formatter
|
http://www.revealnet.com
|
|
SQL/Expediter
|
http://www.compuware.com
|
|
SQL Navigator
|
|
Package Name
|
Use
|
|---|---|
|
HTF
|
Parses HTML
|
|
HTP
|
Generates HTML
|
|
OWA_COOKIE
|
Stores cookies
|
|
OWA_OPT_LOCK
|
Performs record locking
|
|
OWA_PATTERN
|
Searches and replaces text
|
|
OWA_SEC
|
Manages security
|
|
OWA_TEXT
|
Represents text
|
|
OWA_UTIL
|
Improves productivity
|