Oracle9i Application Server Using the PL/SQL Gateway -- Index

! character, ! character, 1-4

backwards compatibility, backwards compatibility, B-2

flexible parameter passing, flexible parameter passing, 1-8

2 parameter

flexible parameter passing, flexible parameter passing, 1-9

4 parameter

flexible parameter passing, flexible parameter passing, 1-9

503 error code, 503 error code, B-5

administration pages

setting access to, setting access to, 4-3

Apache

stopping, stopping, 3-10

applets, applets, 5-8

arrays, arrays, 1-8

authentication, authentication, 2-1

OAS Basic, OAS Basic, 2-2

Authentication Mode, Authentication Mode, 4-5

authorize function, authorize function, 2-3

backwards compatibility, backwards compatibility, B-1

cache settings, cache settings, 4-7

Caching, Caching, 1-19

CGI

environment variables, environment variables, 1-27

owa_util PL/SQL web toolkit package, owa_util PL/SQL web toolkit package, 5-2

REMOTE_USER, REMOTE_USER, 2-4

cgi_env_list

definition, definition, 4-7

client request, client request, 1-2

compatibility with OAS, compatibility with OAS, B-1

configuration

DAD, DAD, 4-1

PL/SQL Gateway, PL/SQL Gateway, 3-8, 4-1

WebDB, WebDB, A-1

configuration file

global settings, global settings, 4-2

content column, content column, 1-12

content_type column, content_type column, 1-12

controlling database processes, controlling database processes, B-3

cookies, cookies, 5-9

owa_cookie PL/SQL web toolkit package, owa_cookie PL/SQL web toolkit package, 5-3

Create a Stateful Session?, Create a Stateful Session?, 4-5

custom authentication, custom authentication, 2-2

custom owa, custom owa, 2-2

DAD

configuring, configuring, 4-1

definition, definition, 1-2

name, name, 4-2

DAD_charset column, DAD_charset column, 1-13

database

locking, locking, 5-4

setting password, setting password, 4-4

database processes

mod_plsql requests, mod_plsql requests, B-3

date utility

in owa_util package, in owa_util package, 5-2

deauthentication, deauthentication, 2-2

debugging, debugging, B-5

direct access URLs, direct access URLs, 1-18

document access path, document access path, 1-14

setting, setting, 4-6

Document Access Procedure, Document Access Procedure, 4-6

document table

setting, setting, 4-6

document table definition, document table definition, 1-11

old style, old style, 1-13

document_path, document_path, 1-14

document_proc, document_proc, 1-14

document_table, document_table, 1-13

download, download, 1-11

downloading files, downloading files, 1-17

DTD, DTD, 1-11

old style, old style, 1-13

dynamic SQL utility

in owa_util package, in owa_util package, 5-2

environment variables

CGI, CGI, 1-25

error code 503, error code 503, B-5

exclusion_list

definition, definition, 4-7

examples, examples, 2-5

Extensions to be Uploaded as LONGRAW, Extensions to be Uploaded as LONGRAW, 4-6

file upload, file upload, 1-11, 1-15

attributes, attributes, 1-17

document table, document table, 4-6

multiple files, multiple files, 1-17

flexible parameter passing, flexible parameter passing, 1-8

exclamation mark, exclamation mark, B-2

four parameter

flexible parameter passing, flexible parameter passing, 1-9

GET method, GET method, 1-6

global owa, global owa, 2-2

global settings, global settings, 4-2

HTML page

invoking an application with, invoking an application with, 6-3

HTML tags

attributes, attributes, 5-8

htp and htf PL/SQL web toolkit packages, htp and htf PL/SQL web toolkit packages, 5-2, 5-3

extensions, extensions, 5-9

HTTP basic authentication, HTTP basic authentication, 2-2

HTTP server listener

configuring, configuring, 3-6

images

owa_image PL/SQL web toolkit package, owa_image PL/SQL web toolkit package, 5-2

installation, installation, 3-1

Keep Database Connection Open Between Requests?, Keep Database Connection Open Between Requests?, 4-5

logging, logging, B-3

login failures, login failures, B-5

LONG datatype, LONG datatype, 5-9

mime type, mime type, 1-17

mod_ose, mod_ose, 1-1

mod_plsql, mod_plsql, 1-1

mod_plsql request, mod_plsql request, B-3

mod_plsql without the /pls, mod_plsql without the /pls, B-1

NLS_LANG, NLS_LANG, 1-28

OAS

Basic Authentication, Basic Authentication, 2-2

upgrading, upgrading, 3-4

OAS compatibility, OAS compatibility, B-1

operating systems

requirements, requirements, 3-1

Oracle Connect String, Oracle Connect String, 4-4

Oracle Password, Oracle Password, 4-4

Oracle User Name, Oracle User Name, 4-4

overloading, overloading, 1-7, 1-8

owa PL/SQL web toolkit package, owa PL/SQL web toolkit package, 5-2

owa_content PL/SQL web toolkit package, owa_content PL/SQL web toolkit package, 5-2, 5-5

owa_cookie PL/SQL web toolkit package, owa_cookie PL/SQL web toolkit package, 5-3

owa_custom PL/SQL web toolkit package, owa_custom PL/SQL web toolkit package, 5-3, 5-4

owa_image PL/SQL web toolkit package, owa_image PL/SQL web toolkit package, 5-2, 5-4

owa_opt_lock PL/SQL web toolkit package, owa_opt_lock PL/SQL web toolkit package, 5-3, 5-4

owa_pattern PL/SQL web toolkit package, owa_pattern PL/SQL web toolkit package, 5-2

owa_pattern.change function/procedure, owa_pattern.change function/procedure, 5-12

owa_pattern.match function, owa_pattern.match function, 5-11

owa_sec PL/SQL web toolkit package, owa_sec PL/SQL web toolkit package, 5-2

owa_text PL/SQL web toolkit package, owa_text PL/SQL web toolkit package, 5-2

owa_util PL/SQL web toolkit package, owa_util PL/SQL web toolkit package, 1-25, 5-2

owaload.sql, owaload.sql, 3-2

parameters

flexible, flexible, 1-8

large, large, 1-10

overloaded, overloaded, 1-7

passing, passing, 1-6, 1-8

PL/SQL web toolkit, PL/SQL web toolkit, 5-7

path alias

setting, setting, 4-6

per package authentication, per package authentication, 2-2

/pls, /pls, B-1

PL/SQL Gateway

applets, applets, 5-8

configuring, configuring, 3-8, 4-1

invoking, invoking, 1-4

tutorial, tutorial, 6-1

PL/SQL procedure

loading into database, loading into database, 6-1

PL/SQL Web Toolkit, PL/SQL Web Toolkit, 5-1

plsql.conf configuration file, plsql.conf configuration file, 3-9

POST method, POST method, 1-6

request_charset, request_charset, 1-28

REQUEST_IANA_CHARSE, REQUEST_IANA_CHARSE, 1-28

response_array_size, response_array_size, 4-7

security

authentication, authentication, 2-1

PL/SQL procedures granted to PUBLIC, PL/SQL procedures granted to PUBLIC, 2-4

Service Temporarily Unavailable error code, Service Temporarily Unavailable error code, B-5

Session Cookie Caching, Session Cookie Caching, 4-9

Session Cookie Name, Session Cookie Name, 4-5

string matching, string matching, 5-10

system requirements, system requirements, 3-1

tnsnames.ora, tnsnames.ora, B-5

transaction model, transaction model, 1-6

tutorial, tutorial, 6-1

two parameter

flexible parameter passing, flexible parameter passing, 1-9

upload, upload, 1-11

upload_as_content_type, upload_as_content_type, 1-14

upload_as_long_raw, upload_as_long_raw, 1-14

wdbsvr.app

configuration file, configuration file, 3-8

web browsers

requirements, requirements, 3-2

web listener

requirements, requirements, 3-2

web toolkit packages

installing, installing, 3-3

WebDB

setting up PL/SQL, setting up PL/SQL, A-1

WebDB listener

upgrading, upgrading, 3-3

Index

Symbols

Numerics

A

B

C

D

E

F

G

H

I

K

L

M

N

O

P

R

S

T

U

W