Index

%ROWTYPE attribute, B-18

%TYPE attribute, B-15, B-17

aliases

for database objects, B-8

for database tables, B-10

ALTER TRIGGER statement (SQL), B-35

anchors

structure of, C-13

used in hypertext linking, C-10

applets

defined, 1-13

embedded in Web pages, 1-14

wrapping in server-side Java, 4-14

application developers, 1-1

applications

components of, 4-1

specifying, 4-4

structure of in Java, 4-17

arrays

implemented as tables in PL/SQL, B-16

assignments

initial, B-14

values to parameters (PL/SQL), B-19

values to variables (PL/SQL), B-20

authentication, 1-5

automatic recompilation (PL/SQL), B-29

basic authentication, 1-5

blocks (PL/SQL), B-13

Boolean logic

IF statements and (PL/SQL), B-21

Three-Valued in SQL, B-6

browsers

Java-enabled, 1-14

bytecode, 1-14

caching

files, 1-5

cattributes, 6-5

cattributes parameter

use in passing exact text, 6-5

certifying authorities, 1-9

CGI, 1-10

environment variables, 4-4, 4-6, 4-30, 6-57

executing from LiveHTML, 4-31

LiveHTML can call, 1-16

variables used by WRB, 1-12

changes

viewing in HTML document, C-15

Common Gateway Interface (CGI), 1-10

compiler directives (PL/SQL), B-25

compression, 1-6

Connect-String, 4-5

constants

declaring (PL/SQL), B-15

constraints (SQL), B-7

cookies, 6-79

correlation variables

in SQL statements, B-10

in triggers, B-34

CREATE FUNCTION statement (SQL), B-27

CREATE PACKAGE BODY statement (SQL), B-31

CREATE PACKAGE statement (SQL), B-30

CREATE PROCEDURE privilege (SQL), B-27

CREATE PROCEDURE statement (SQL), B-27

CREATE TABLE statement (SQL), B-7

crippled LiveHTML, 4-29

cursor variables (PL/SQL), B-18

cursors (PL/SQL), B-18

in package specifications, B-30

data structures

in PL/SQL, B-16

databases

access control, 1-13, 4-5

changing data content of, B-8

connecting to, 4-5, 4-15

connecting to in Java, 4-17

constraining, B-7

creating objects in using PL/SQL, B-12

creating tables in, B-7

database triggers, B-32

interfacing to, B-5

missing data in, B-6

nulls used in, B-6

referencing objects in, B-7

removing data from, B-9

retrieving data from, B-6

storing code in, B-12, B-27, B-32

datatypes

composite, B-14

converting, B-14

in OWA_PATTERN, 6-66

inheritance of (PL/SQL), B-15

OWA_TEXT uses, 6-75

PL/SQL, B-14

PL/SQL Agent limitations, 4-12

PL/SQL vs. Java, 4-17

PL/SQL WebToolkit, 6-5

pointer, B-14

RECORD (PL/SQL), B-17

scalar, B-14

SQL, B-7

structured, B-14

TABLE (PL/SQL), B-16

user-defined, B-15

user-defined in PL/SQL, B-17

DATE_GMT, 4-30

DATE_LOCAL, 4-30

DBMS_SQL package, B-12

DBMSSTDX.SQL script, B-29

DCDs, 4-15

format of, 4-5

how specified, 1-12, 4-4

optimizing for multiple, 6-3

specified in URLs, 1-13

declarations

constants (PL/SQL), B-15

subprograms (PL/SQL), B-19

types (PL/SQL), B-15

variable (PL/SQL), B-14

DECLARE section (PL/SQL), B-13

DELETE statement (SQL), B-9

digest authentication, 1-5

digital signatures, 1-9

DNS, 1-4

DOCUMENT_NAME, 4-30

DOCUMENT_URL, 4-30

domain names, 1-4

domains

restricting access to specified, 1-6

dot notation

for database objects, B-7

for PL/SQL objects and subprograms, B-15–B-16

encryption

communications, 1-7

password, 1-5

public key, 1-8

session keys, 1-8

environment variables, 4-30

retrieving, 6-57

error handling

Java, 4-17

LiveHTML, 4-29

Oracle7, B-24

PL/SQL, B-24

PL/SQL Agent, 4-12

triggers and, B-34

exceptions (PL/SQL), B-24

declared in DECLARE section, B-19

declaring, B-25

predefined, B-24

user-defined, B-26

EXECUTABLE section (PL/SQL), B-20

EXECUTE privilege (SQL), B-27

EXIT statement (PL/SQL), B-24

extensions

filename, 1-6

extra path information, 4-3

fields

in PL/SQL records, B-17

file sharing, 1-5

files

access control, 1-5

caching, 1-5

compression of, 1-6

filename extesions, 1-6

language of, 1-6

MIME types, 1-6

firewalls, 1-4

flow control (PL/SQL), B-20

FOR loops (PL/SQL), B-23

FOR UPDATE clause (PL/SQL), B-18

forced line breaks, C-6

foreign keys

joins using, B-9

Form tags, C-21

Input, C-22

TextArea, C-21

form tags, 6-42

forms, C-20

multivalued parameters, 4-9

parameter passing through, 4-7

selection menus, C-24

syntax, C-20

frame tags

HTML frame tags, 6-29

FTP, C-12

functions, B-19

grouped into packages, B-28

return values of (PL/SQL), B-20

storing in database, B-27

GET, 4-6–4-7

GOTO statement (PL/SQL), B-23

error handling and, B-26

graphics, 6-78

image maps, 1-15

within HTML documents, C-13

host names, 1-4

HTML

basic concepts, C-2

case sensitivity, C-3

comments in, 4-29

dynamically generating

Web pages

dynamic, 4-4

extending, 6-63

form tags, 6-42

introduction, C-1

Java generates dynamic, 4-24

list tags, 6-31

print tags, 6-6

structure tags, 6-7

table tags, 6-51

HTML Tags

ADDRESS, C-16

BLOCKQUOTE, C-7

BODY, C-5

BOLD, C-15

CAPTION, C-18

definition list, C-10

escape sequence, C-17

getting started, C-3

HEAD, C-4

heading level, C-5

I, C-15

lists, C-8

mono spaced, C-15

nested list, C-9

ordered list, C-8

P, C-5

PRE, C-5

TABLE, C-18

TD, C-18

TH, C-18

TITLE, C-4

TR, C-18

U, C-15

unordered list, C-9

HTTP, C-11

HyperText Markup Language, C-1

HyperText Procedures

body tags, 6-13

character format tags, 6-37

definition of, 6-1

form tags, 6-42

head-related tags, 6-10

list tags, 6-31

physical format tags, 6-41

printing procedures, 6-6

structural tags (HTML), 6-7

table tags, 6-51

IF statement (PL/SQL), B-21

image maps

defined, 1-15

dynamic, 1-15, 6-78

initialization section (PL/SQL packages), B-31

input parameters, B-19

INSERT statement (SQL), B-8

int_array, 6-75

IP addresses, 1-3

restricting access to specified, 1-6

ISMAP attribute, C-14

Java

application structure, 4-17

client side, 1-14

database connections, 4-17

error handling, 4-17

generating HTML from, 4-24

NULL handling in, 4-18

overview of, 1-13

PL/SQL combined with, 1-15

PL/SQL datatypes in, 4-17

proscribes direct memory management, 1-14

server side, 1-14, 4-14

wrappers for PL/SQL, 4-15

joins, B-9

natural, B-9

outer, B-10

labels

PL/SQL, B-23

languages

file formats and, 1-6

specified for WRBXs, 1-12

LAST_MODIFIED, 4-30

links

to other documents, C-10

to other sections, C-14

list tags, 6-31

definition, C-10

nested, C-9

ordered, C-8

types of, C-8

unordered, C-9

Listener, 1-3

LiveHTML

environment variables, 4-30

executing programs from, 4-31

overview of, 1-15

PL/SQL Agent can be called from, 1-16

tags, 4-29

loops (PL/SQL), B-22

exiting nested, B-24

FOR, B-23

WHILE, B-23

mailto, C-11

memory

management of, 1-5

proscribed in Java, 1-14

multi_line, 6-75

naming conventions

PL/SQL, B-16

tables, B-17

SQL, B-7

natural joins, B-10

NLS

file formats and, 1-6

NOT NULL constraint (SQL), B-7

PL/SQL use of, B-14

NULL statement (PL/SQL), B-22

nulls

as Boolean values, B-6

database contains, B-6

differentiated from NULL statement, B-22

outer joins generate, B-10

prohibiting, B-7, B-14

SQL handling of, B-6

UPDATE statement (SQL) generates, B-9

variables initialized to (PL/SQL), B-14

objects

ownership of database, B-7

oracle.html(Java package), 4-14

oracle.plsql(Java package), 4-14

oracle.rdbms(Java package), 4-14

ORACLE_HOME, 4-5

outer joins, B-10

output parameters, B-19

overloading

PL/SQL procedures, 4-12

overloading subprograms

PL/SQL, B-31

owa, 6-3

OWA Utilities package

description of, 6-2

OWA_COOKIE, 6-79

OWA_IMAGE, 6-78

OWA_PATTERN, 6-63

OWA_TEXT, 6-75

OWA_UTIL Package, 6-55

OWAINS.SQL, 6-3

packages, B-28

creating, B-29

specification, B-30

parameters

actual (PL/SQL), B-19

formal (PL/SQL), B-19

in PL/SQL, B-19

in PL/SQL packages, B-31

modes of (PL/SQL), B-19

multivalued, 4-9

passing through forms, 4-7

parent keys, B-4

PATH_INFO, 4-4, 4-6

PL/SQL

blocks, B-13

datatypes

Java encapsulation of, 4-17

declarations, B-13

DECLARE section, B-13

embedding dynamic output in static Web pages, 1-16

EXCEPTION section, B-24

EXECUTABLE section, B-20

flow control in, B-20

generating dynamically, B-12

GOTO restrictions, B-24

Java combined with, 1-15

overloading subprograms, B-31

parameter passing, 4-4, 4-6

procedures

overloading, 4-12

scope of objects and subprograms, B-16

sections of, B-13

subprograms, B-13

user-defined datatypes in, B-15

PL/SQL Agent, 4-4

connect to database, 4-15

database access of, 1-13

datatype limitations, 4-12

environment variables, 4-6

error handling, 4-12

Java circumvents, 4-14

LiveHTML can call, 1-16

multiple DCDs, 6-3

PL/SQL Agents, 1-12

PL/SQL packages

bodies, B-31

Java wrappers for, 4-15

PL/SQL tables

datatype limitations, 4-12

PL/SQL Web Toolkit

datatypes used, 6-5

installation, 6-3

ownership of, 6-3

PL/SQL WebToolkit, 6-1

installing", 6-3

procedures and functions, 6-1

security considerations, 6-4

usingOWAINS.SQL to install, 6-3

pl2java, 4-15

ports, 1-3

specifying in URLs, 4-3

POST, 4-6–4-7

pragmas (PL/SQL), B-25

predicates, B-6

in IF statements (PL/SQL), B-21

primary keys

enforcing, B-7

print tags, 6-6

private synonyms, B-8

privileges

object, B-5

required to create triggers, B-34

stored procedures require, B-27

stored procedures use, B-27

system, B-5

PRIVUTIL.SQL, 6-4

procedures

declaring, B-19

grouped into packages, B-28

storing in database, B-27

procedures and functions

getting started, 6-5

proxy servers, 1-4

public key encryption, 1-8

public synonyms, B-8

PUBUTIL.SQL, 6-4

queries (SQL), B-6

multiple tables used in, B-9

stored in cursors (PL/SQL), B-18

within other queries (subqueries), B-10

query strings, 4-3

QUERY_FORM, 4-9

QUERY_STRING, 4-6

QUERY_STRING_UNESCAPED, 4-30

RAISE statement (PL/SQL), B-26

range variables, B-10

records

PL/SQL datatype, B-17

ref cursors (PL/SQL), B-14

regular expessions, 6-63

reload, C-15

REQUEST_METHOD, 4-6–4-7

restriction, 1-6

RETURN statement (PL/SQL), B-20

return values

cursor (PL/SQL packages), B-30

functions (PL/SQL), B-20

row_list, 6-76

schemas, B-7

scope

of PL/SQL objects and subprograms, B-16

PL/SQL packages and, B-31

SCRIPT_NAME, 4-4, 4-6

security

certifying authorities, 1-9

DCD, 4-5

digital signatures, 1-9

encryption, 1-7

file access, 1-5

PL/SQL Agent, 1-13

PL/SQL Web Toolkit, 6-4

proxy Internet connections, 1-4

public key encryption, 1-8

session keys, 1-8

SSL, 1-7

SELECT statement (SQL), B-6

server extensions, 4-2

Server Side Includes

same as LiveHTML, 1-15

session keys, 1-8

SGML comments, 4-29

SHTML, 4-29

sockets

defined, 1-4

SQL, B-5

dynamic, B-12

predicates, B-6

standards, B-5

Three-Valued Logic (TRUE, FALSE, NULL) in, B-6

SQLCODE, B-24

SQLERRM, B-24

SSL

Overview of, 1-7

STANDARD package (PL/SQL), B-24

stored procedures, B-27

string matching, 6-63

structure tags, 6-7

subprograms (PL/SQL), B-13

declaring, B-19

error handling and, B-26

GOTO restrictions, B-24

overloading, B-31

parameters of, B-16

resolving ambiguous references, B-16

scope and visibility of, B-16

subqueries (SQL), B-10

subtypes (PL/SQL), B-15

using to create PL/SQL records, B-17

using to create PL/SQL tables, B-17

synonyms

for database objects, B-8

Table attributes

Align, C-19

Border, C-19

Colspan, C-19

Colspec, C-19

Nowrap, C-19

Rowspan, C-19

Valign, C-19

table tags, 6-51

Tables

in HTML, C-17

tables

database, B-7

aliases for, B-8, B-10

HTML, 4-9

ownership of, B-7

passing as parameters in PL/SQL, B-16

PL/SQL, B-17

PL/SQL datatype, B-16

stored in cursors (PL/SQL), B-18

TCP/IP, 1-3

text/x-server-parsed-html, 4-29

text-only browsers, C-14

Three-Valued Logic (TRUE, FALSE, NULL), B-6

addressing in Java, 4-18

triggers, B-32

altering, B-33

creating, B-33

enabling and disabling, B-35

Uniform Resource Locator (URL), C-11, C-13

unique keys, B-4

UPDATE statement (SQL), B-9

URL, C-13

URLs, C-10

DCDs used in, 1-13

GET vs. POST, 4-7

interpretation of, 4-3

parameter ordering, 4-9

specifying PL/SQL Agent with, 1-12

specifying ports in, 4-3

specifying secure connections with, 1-4

use of "owa" in, 1-12

use virtual file names, 1-4

used in applications, 4-1

usernames

specified in DCDs, 4-5

users

schemas and, B-7

variables

assigning values to (PL/SQL), B-20

cursor, B-14, B-18

declaring (PL/SQL), B-14

in triggers, B-34

initializing

in PL/SQL packages, B-31

instantiation in PL/SQL packages, B-29

vc_array, 6-75

virtual file systems

defined, 1-4

Virtual Machines (VMs), 1-14

virtual paths, 4-3

visibility

of PL/SQL objects and subprograms, B-16

PL/SQL packages and, B-31

Web Listener, 1-3

Web Listeners

control WRBX load, 1-12

file type negotiation, 1-6

interpret URLs, 1-2

memory management, 1-5

Overview of, 1-3

Web pages

applications and, 4-1

dynamic, 1-15, 4-2

from Java, 4-24

including in LiveHTML, 4-29

dynamic data embedded in static, 1-16

embedded, 4-29

Web Request Broker (WRB), 1-11

WebServer

executing Java on, 1-14

Overview of, 1-2

WebServer Administrators, 1-1

WebServer Manager

overview of, 1-9

WHILE loops (PL/SQL), B-23

WRB, 1-11

CGI environment variables and, 4-6

overview of, 1-2

WRB cartridges

defined, 1-2

WRB Dispatchers

how invoked, 4-4

WRB Services

defined, 1-2

WRBXs

allocation of requests to, 1-12

connect to database, 4-15

connecting to database, 1-12

data passed to, 1-12

defined, 1-2

single-threaded, 1-12

Go to the Table of Contents.