Read it Now!
Reprint Licensing
Oracle Web Applications:  PL/SQL Developer's Intro
Oracle Web Applications: PL/SQL Developer's Intro Developer's Introduction

By Andrew Odewahn

Cover | Table of Contents | Colophon


Index


[ Symbols ], 
[ A ], 
[ B ], 
[ C ], 
[ D ], 
[ E ], 
[ F ], 
[ G ], 
[ H ], 
[ I ], 
[ J ], 
[ K ], 
[ L ], 
[ M ], 
[ N ], 
[ O ], 
[ P ], 
[ Q ], 
[ R ], 
[ S ], 
[ T ], 
[ U ], 
[ V ], 
[ W ], 
[ X ]

Symbols[ Top ]
assertion, OWA_PATTERN package, 144
& special character, OWA_PATTERN package, 144
( ) special character, OWA_PATTERN package, 144
* quantifier, OWA_PATTERN package, 143
+ quantifier, OWA_PATTERN package, 143
. atom, OWA_PATTERN package, 143
<a>...</a> tag, HTML, 91
<b>...</b> tag, HTML, 89
<body>...</body> tag, HTML, 89
<br>...</br> tag, HTML, 90
<center>...</center> tag, HTML, 90
<font>...</font> tag, HTML, 89
<form>...</form> tag, HTML, 95-96
<head>...</head> tag, HTML, 89
<hn>...</hn> tag, HTML, 90
<hr>...</hr> tag, HTML, 90
<html>...</html> tag, HTML, 88
<i>...</i> tag, HTML, 90
<input> tag, HTML, 96-99
<li>...</li> tag, HTML, 91
<ol>...</ol> tag, HTML, 91
<option>...</option> tag, HTML, 96
<p>...</p> tag, HTML, 90
<pre>...</pre> tag, HTML, 90
<select>...</select> tag, HTML, 96, 99
<small>...</small> tag, HTML, 90
<sup>...</sup> tag, HTML, 90
<table>...</table> tag, HTML, 93
<textarea>...</textarea> tag, HTML, 96, 100
<th>...</th> tag, HTML, 93
<title>...</title> tag, HTML, 89
<tr>...</tr> tag, HTML, 93
<tt>...</tt> tag, HTML, 90
<ul>...</ul> tag, HTML, 91
? quantifier, OWA_PATTERN package, 143
\b atom, OWA_PATTERN package, 143
\c atom, OWA_PATTERN package, 143
\D atom, OWA_PATTERN package, 143
\d atom, OWA_PATTERN package, 143
\n atom, OWA_PATTERN package, 143
\nnn atom, OWA_PATTERN package, 143
\S atom, OWA_PATTERN package, 143
\s atom, OWA_PATTERN package, 143
\t atom, OWA_PATTERN package, 143
\W atom, OWA_PATTERN package, 143
\w atom, OWA_PATTERN package, 143
\xnn atom, OWA_PATTERN package, 143
^ assertion, OWA_PATTERN package, 144
{n,} quantifier, OWA_PATTERN package, 143
{n,m} quantifier, OWA_PATTERN, 143

A[ Top ]
abstract data types (ADTs), 124
accounts payable, 2
accounts receivable, 2
Active Server Pages, 6
actual parameters, 107
ADD2MULTI procedure, OWA_TEXT package, 140
Adobe PDF, 19
ADTs (abstract data types), 124
Advanced Networking Option (ANO), 48
Advanced Queuing (AQ), 10, 20-23
AIFF format, 19
Alpha, 7
AltaVista, 4
AMATCH function, OWA_PATTERN package, 145, 147
ANCHOR function, HTF package, 138
ANCHOR procedure, HTP package, 134
anchored declarations, 114
ANO (Advanced Networking Option), 48
answer_survey procedure, EMP_SURVEY package, 187-189
APIs (application programming interfaces), 18, 124
applets, Java, 6
application development, 1-3, 6-7, 14
application integration and electronic data interchange, 1-3, 7-8
application programming interfaces (APIs), 18, 124
application servers, 6
AQ (Advanced Queuing), 10, 20-23
AQ Lite, 18
assertions, OWA_PATTERN package, 144
asynchronous mode, replication, 17
attributes, HTML, 85
AUF format, 19
AVI format, 19, 27

B[ Top ]
back references (backrefs), OWA_PATTERN package, 144
BEGIN command, PL/SQL, 104
blocks, 103-104
body, HTML form tag, 88
body, PL/SQL, 103
bottom-up design, PL/SQL, 103
broken links, 5
browser-specific extensions, HTML, 101

C[ Top ]
C, 6, 16, 103
C++, 6, 103
CA (certification authority), 48
calendar wizard, WebDB, 57
cartridges, 6, 76-77
CASE statements, 104, 116
CAST Workbench, 130
categories, WebDB dashboard, 63-64
certification authority (CA), 48
CGI (common gateway interface), 6, 72-76
CHANGE function, OWA_PATTERN package, 145, 148-150
chart wizard, WebDB, 58
CHECKSUM procedure, OWA_OPT_LOCK package, 158, 161-163
COBOL, 1, 6, 20, 103
colors library, WebDB, 59
COM, 8
comment, HTML form tag, 88
common gateway interface (CGI), 6, 72-76
complete refresh, 17
connecting databases to Web, 23
content delivery model, 33-37
      HTTP listener, 35-36
      PL/SQL gateways, 36-37
content management, 1-6, 14
CORBA, 8, 15
create_msg_form procedure, FORUM package, 210-211
create_user_form procedure, FORUM_USERS package, 204-205
current_forum_list procedure, FORUM package, 208-209
cursors
      declaring, 118-119
      implicit, 121
      processing, 119-121

D[ Top ]
DAD (see Database Access Descriptor)
dashboards, WebDB, 62
data warehousing, 1-2
Database Access Descriptor (DAD), 31, 34-36, 66-67
Database Access Descriptor Name parameter, DAD, 66
database administration, 14
database integration, 37-41
      PL/SQL example, 38-41
      PL/SQL toolkit, 37-38
database security, 42-49
      objects, 42-43
      privileges, 43-45
      roles, 45-47
      users, 42
datatype indicators, HTP package, 135
datatype parameter, PL/SQL, 107, 113-114
DBDOM package, 227
DBXML package, 226-227
DBXSL package, 227
declaration section, PL/SQL, 103
DECLARE keyword, PL/SQL, 103
default (home) page parameter, DAD, 67
default MIME type parameter, server settings, 69
default values, PL/SQL, 107, 114
dequeuing, 21
Developer/2000 applications, 16
developing web applications, 23
digital certificates, 48
disaster planning, 8
display_survey_list procedure, EMP_SURVEY package, 186-187
DLL (Dynamic Link Library), 18
DNS (Domain Name Server), 29
Document Access Path parameter, DAD, 67
Document Access Procedure parameter, DAD, 67
Document Table parameter, DAD, 67
document type definition (DTD), 219-221
Domain Name Server (DNS), 29
DOS, 4
DTD (document type definition), 219-221
Dynamic Link Library (DLL), 18
dynamic page wizard, WebDB, 58
dynamic resources, 6, 27-28

E[ Top ]
e-commerce (electronic commerce), 1-2
EJB (Enterprise Java Beans), 15
email, 2
EMP_SURVEY package, 185-193
      answer_survey procedure, 187-189
      display_survey_list procedure, 186-187
      process_survey procedure, 189-190
      view_results procedure, 190-192
encryption, 48
END command, PL/SQL, 104
END LOOP command, PL/SQL, 117
enqueuing, 21
Enterprise Java Beans (EJB), 15
enterprise resource planning (ERP)
systems, 1-2
EnterpriseSync Lite (ESL), 17-18
ERP (enterprise resource planning), 1-2
ESL (EnterpriseSync Lite), 17-18
Eudora, 10, 17
executable section, PL/SQL, 103
EXECUTE permission, PL/SQL, 111

F[ Top ]
fast refresh, 17
file attributes, 4
file extensions, 70
filesystems, 4
file, WebDB dashboard, 62
firewalls, 48
flags, OWA_PATTERN package, 144
folderlink, WebDB dashboard, 62
folders, WebDB dashboard, 63
fonts library, WebDB, 59
form wizard, WebDB, 58
formal procedures, PL/SQL, 107
forms HTML, 40
FORTRAN, 6
FORUM package, 206-212
      create_msg_form procedure, 210-211
      current_forum_list procedure, 208-209
      print_thread_links procedure, 207-208
      save_message procedure, 211-212
      view_message procedure, 209-210
FORUM_USERS package, 199-206
      create_user_form procedure, 204-205
      get_current_user function, 204
      login procedure, 202-203
      save_user_info procedure, 204-205
frame driver wizard, WebDB, 58
FROG (Funky Resource for Oracle Gorillas), 130
FrontPage, 19
FTP, 10
function wizard, WebDB, 55

G[ Top ]
g flag, OWA_PATTERN package, 144
gateways, PL/SQL, 36-37
GENERAL_FORM package, 197-199
geographic information system (GIS), 19
GET function, OWA_COOKIE package, 153, 155-156
GET_ALL procedure, OWA_COOKIE package, 153, 156
get_attribute function, XML_INVOICE_PKG, 222-223
GET_CLIENT_HOSTNAME procedure, OWA_SEC package, 179
GET_CLIENT_IP procedure, OWA_SEC package, 38, 179
get_current_user function, FORUM_USERS package, 204
GET_PASSWORD procedure, OWA_SEC package, 179
GET_PAT function, OWA_PATTERN package, 145
GET_ROWID procedure, OWA_OPT_LOCK package, 158, 160-161
GET_USER_ID procedure, OWA_SEC package, 38, 179
GIF format, 6, 19, 27
GIS (geographic information system), 19
GRANT EXECUTE command, 111-112
groups, WebDB, 64

H[ Top ]
hackers, 2
handlers, 104
hardware platforms, 6
head, HTML form tag, 88
HEADCLOSE procedure, HTP package, 135
header section, PL/SQL, 103
HEADOPEN procedure, HTP package, 135
hierarchy wizard, WebDB, 58
HTF package, 37
      ANCHOR function, 138
      PRINT function, 138
HTML, 2, 6, 9, 11-12
      attributes, 85
      browser-specific extensions, 101
      forms, 40
      learning, 84
      programming in, 83-86
      reasons for using, 24-25
      static resources, 27
      syntax, 84-86
      tags, 84-85
           

  • anchor, 87, 91

  •             content flow, 87, 90-91
                form, 88, 95-101
                list, 87, 91-92
                structural, 87-88
                table, 87, 93-94
                text formatting, 87, 89-90
    HTMLCLOSE procedure, HTP package, 135
    HTMLOPEN procedure, HTP package, 134
    HTP package, 37
          ANCHOR procedure, 134
          HEADCLOSE procedure, 135
          HEADOPEN procedure, 135
          HTMLCLOSE procedure, 135
          HTMLOPEN procedure, 134
          PRINT procedure, 134
    HTTP, 10
    HTTP listener, 35-36
    hybrid sites, 2
    hybrid systems, 6

    I[ Top ]
    I flag, OWA_PATTERN package, 144
    IF-THEN conditional statements,
    PL/SQL, 116
    IF-THEN-ELSE conditional statements, PL/SQL, 116
    i FS (Internet File System), 9-11, 227-228
    imagemap, WebDB dashboard, 62
    images, 2
    images library, WebDB, 60
    IMAP4, 10
    index wizard, WebDB, 55
    index-by table
          adding elements to, 123
          creating, 122-123
          retrieving elements from, 123-124
    information hiding, 128-129
    inheritance, 42
    int_arr data structure, OWA_TEXT
    package, 139
    Intel, 6
    internal applications, 2
    Internet File System ( i FS), 9-11, 227-228
    Internet storefronts, 2
    Internet technology, overview, 1-8
    InternetLite, 9, 16-18
    InternetLite server and API, 18
    invoices, 2

    J[ Top ]
    Java, 9-10
          applets, 6
          dynamic resources, 28
          Enterprise Java Beans (EJBs), 15
          Java Access Classes (JACs), 16
          Java stored procedures (JSPs), 15
          JavaScripts library, 60
          servlets, 6, 15-16
    JDBC, 15-16, 65
    JPEG format, 6, 19, 27

    K[ Top ]
    Keep Database Connection Open between Requests? parameter, DAD, 67

    L[ Top ]
    LAN (local area network), 2, 27
    laptops, 2
    learning HTML, 84
    limitation, CGI interface, 75-76
    links, 5
    links library, WebDB, 60
    Linux, 29
    lists of values (LOV) library, WebDB, 60
    location transparency, 46
    logging level parameter, server settings, 69
    LOOP command, PL/SQL, 117

    M[ Top ]
    master sites, 16
    MATCH function, OWA_PATTERN
    package, 145-146
    Maximum Number of Worker Threads parameter, DAD, 67
    menu wizard, WebDB, 58
    metadata, 5
    metainformation, 86
    Microsoft
          Access, 16-17
          Excel, 4, 10, 19
          FrontPage, 3, 6
          Internet Explorer, 30
          Outlook, 10, 17
          PowerPoint, 19
          Windows 95, 29
          Windows 98, 29
          Windows NT, 6, 29
          Word, 19
    MIME (Multipurpose Internet Mail Extensions), 32-33
    MIME type, WebDB, 70
    mobile applications, 2, 16
    mode, PL/SQL, 107
    MPEG format, 19, 27
    multi_line data structure, OWA_TEXT package, 139
    multimedia data, 2, 18-19

    N[ Top ]
    name value, PL/SQL, 113
    named notation, PL/SQL, 108-110
    Net8, 30, 48
    Netscape Communicator, 30
    NEW_MULTI procedure, OWA_TEXT package, 140
    NEW_ROW_LIST procedure, OWA_TEXT package, 140
    normal procedure calls, 41

    O[ Top ]
    OAS (see Oracle Application Server)
    object privileges, 44-45
    Object Request Brokers (ORB), 6
    object wizards, WebDB, 55
    objects, 42-43
    OCA (Open Client Adapter), 16
    OCI (Oracle Call Interface), 16
    OEM (Oracle Enterprise Manager), 14
    Open Client Adapter (OCA), 16
    optimistic versus pessimistic locking, 157
    Oracle Application Server (OAS), 9, 14
          dynamic resources, creating, 78-82
          web resources, returning, 72-78
    Oracle Audio/Video Server, 19
    Oracle Call Interface (OCI), 16
    Oracle Connect String parameter, DAD, 67
    Oracle Enterprise Manager (OEM), 14
    Oracle Forms, 7, 17
    Oracle interMedia, 9, 18-19
    Oracle Lite, 16-17
    Oracle Password parameter, DAD, 66
    Oracle Procedure Builder, 130
    Oracle Spatial cartridge, 18-19
    Oracle User Name parameter, DAD, 66
    Oracle8i, overview, 1, 8-10, 22-26
    ORB (Object Request Broker), 6
    order entry systems, 2
    OS/2, 29
    OWA_COOKIE package, 37
          GET function, 153, 155-156
          GET_ALL procedure, 153, 156
          REMOVE procedure, 153, 155
          SEND procedure, 153-155
    OWA_IMAGE package, 37
    OWA_OPT_LOCK package, 37, 156-163
          CHECKSUM procedure, 158, 161-163
          GET_ROWID procedure, 158, 160-161
          STORE_VALUES procedure, 158-159
          VERIFY_VALUES procedure, 158, 160
    OWA_PATTERN package, 38, 143-147
    OWA_SEC package, 38, 179
    OWA_TEXT package, 38
          ADD2MULTI, 140
          int_arr data structure, 139
          multi_line data structure, 139
          NEW_MULTI procedure, 140
          NEW_ROW_LIST procedure, 140
          PRINT_MULTI procedure, 140
          PRINT_ROW_LIST procedure, 140
          row_list data structure, 139
          STREAM2MULTI procedure, 140
          vc_arr data structure, 139
    OWA_UTIL package, 38, 153-154, 163-178
          BIND_VARIABLES procedure, 163, 172, 174-175
          CALENDARPRINT procedure, 163, 172, 177-178
          CELLSPRINT procedure, 163, 172, 175-176
          CHOOSE_DATE procedure, 163, 167-168
          DATETYPE datatype, 163, 167-168
          debugging, 164
          GET_CGI_ENV procedure, 163, 165-166
          GET_OWA_SERVICE_PATH function, 163, 165, 167
          GET_PROCEDURE function, 163, 165
          HTML and HTTP, 168-169
          HTTP_HEADER_CLOSE procedure, 163, 168, 171
          IP_ADDRESS datatype, 164, 166-167
          LISTPRINT procedure, 164, 172, 176-177
          MIME_HEADER procedure, 164, 168-170
          PRINT_CGI_ENV procedure, 164, 166
          querying the environment, 165-166
          REDIRECT_URL procedure, 164, 169-171
          representing dates, 167
          SHOWPAGE procedure, 164-165
          SHOWSOURCE procedure, 164
          SIGNATURE procedure, 164, 169
          STATUS_LINE procedure, 164, 169-170
          TABLEPRINT function, 164, 171-174
          TODATE function, 164, 167-168
          WHO_CALLED_ME procedure, 164-165

    P[ Top ]
    package wizard, WebDB, 56
    PalmPilots, 2
    parameter arrays, 40
    parameter name, PL/SQL, 107
    parameter passing, PL/SQL, 80
    Pascal, 102
    PDA (Personal Data Assistant), 2
    Perl, 6-7, 28
    Personal Data Assistant (PDA), 2
    perspectives, WebDB, 64
    physical directories, WebDB, 69
    PL/Formatter, 130-132
    PL/SQL, 7, 9, 13, 20
          calling procedures and functions, 108-110
          comments, 112-115
          conditionals, 116
          cursors, 118-121
          declaration section, 103
          dynamic resources, 28
          example, 38-41
          exception section, 104
          executable section, 103
          functions, 105-106
          gateways, 36-37, 40
          header section, 103
          index-by tables (arrays), 122-124
          information hiding, 128-129
          largest string size, 138-139
          loops, 116-118
          overloading, 110-111
          packages, 124-130
          parameters, 107-108
          permissions, 111-112
          PL/Formatter, 131-132
          procedures, 104-105
          programming constructs, 112-124
          reasons to use, 25-26
          structured programming in, 102-112
          TOAD, 130-131
          toolkit, 34, 37
          tools, 130-132
          variable persistence throughout a session, 129-130
          WebAlchemy, 136-137
    PL/SQL call, WebDB dashboard, 62
    PL/SQL toolkit
          HTF package, 137-138
          HTP package, 134-136
          OWA_COOKIE package, 152-156
          OWA_IMAGE package, 37
          OWA_LOCK, 156-163
          OWA_PATTERN package, 142-159
          OWA_SEC package, 179
          OWA_TEXT package, 138-142
          OWA_UTIL package, 163-178
    PLEdit, 130
    PLSXML utilities and demos, 226-227
    polymorphism, 42
    POP3, 10
    port 21, TCP/IP, 30
    port 25, TCP/IP, 80
    port 80, TCP/IP, 30
    portable devices, 2
    positional notation, 108-109
    PowerBuilder, 16
    PRINT function, HTF package, 138
    PRINT procedure, HTP package, 134
    print_invoice procedure, XML_INVOICE_PKG, 225-226
    print_items procedure, XML_INVOICE_PKG, 222, 224-225
    PRINT_MULTI procedure, OWA_TEXT package, 140
    PRINT_ROW_LIST procedure, OWA_TEXT package, 140
    print_thread_links procedure, FORUM package, 207-208
    print_xml_tag procedure, XML_INVOICE_PKG, 222-224
    privileges, 43-45, 53, 65
    Pro*COBOL, 20
    Procedural Language (PL), 102
    procedure wizard, WebDB, 56
    process_survey procedure, EMP_SURVEY package, 189-190
    programming in HTML, 83-86

    Q[ Top ]
    Qualcomm Eudora, 10, 17
    Query by Example (QBE) forms, 58
    query strings, 40
    Quicktime format, 19

    R[ Top ]
    real arrays versus index-by tables, 122
    RealNetworks, 19
    reasons for using HTML, 24-25
    record locking, OWA_OPT_LOCK package, 156-163
    refresh options, 17
    RegExp (regular expressions), OWA_PATTERN package, 142-143
    relational database management systems (RDBMSs), 8
    REMOVE procedure, OWA_COOKIE package, 153, 155
    REPAPI (Replication API), 17
    replication modes, ESL, 17
    report wizard, WebDB, 58
    resources, 27-28
    result sets, 118
    RETURN command, PL/SQL, 106
    RevealNet, 131-132
    roles, 45-47, 53
    root privileges, 29
    row_list data structure, OWA_TEXT package, 139

    S[ Top ]
    sales force automation, 2
    save_message procedure, FORUM
    package, 211-212
    search engines, 4-5
    searchable attributes, 5
    Secure Socket Layer (SSL), 48
    security, 42-49, 53
          anonymous survey application, 192
          discussion forum package, 192
          OWA_SEC package, 38, 179
    security ( continued )
          PL/SQL cartridge, 81-82
          system privileges, 43-44
          WebDB, 53
    SEND procedure, OWA_COOKIE package, 153-155
    sequence wizard, WebDB, 56
    Server Port parameter, server settings, 69
    server-to-client communications, 28
          analogy between Web and phone system, 33
          communication ports, 29
          HTTP (hypertext transfer protocol), 29-30
          resource MIME type, 32-33
          TCP/IP networks, 28-29
          URL (Uniform Resource Locator), 31-32
          web browsers, 30-31
    servlets, Java, 6, 15-16
    SET_AUTHORIZATION procedure, OWA_SEC package, 179
    SET_PROTECTION_REALM procedure, OWA_SEC package, 179
    SGML (Standardized General Markup Language), 214
    shared component libraries, 59-60
    signatures, 110
    site administrators, 64
    SMB, 10
    SMTP, 10
    snapshot sites, 16
    software development kit (SDK), 60
    software port, 29
    Sparc, 7
    spreadsheets, 2, 4
    SQL Navigator, 130
    SQL Programmer, 130
    SQL Station, 130
    SQL*Net, 30, 48
    SQL*Object Builder, 130
    SQL/Expediter, 130
    SQLJ, 15
    SSL (Secure Socket Layer), 48
    state versus stateless, 30
    static resources, 27-28, 73-74
    stdout, 14
    STORE_VALUES procedure, OWA_OPT_LOCK package, 158-159
    storyboards, creating, 181-182
    STREAM2MULTI procedure, OWA_TEXT package, 140
    streaming servers, 19
    Sun Ultraservers, 6
    SWITCH statements, 116
    Symantec Visual Page, 19
    synchronous mode, replication, 17
    synonym wizard, WebDB, 56
    synonyms, 46
    syntax HTML, 84-86
    system privileges, 43-44

    T[ Top ]
    table data, 2
    table wizard, WebDB, 56
    tags, HTML
          anchor tags, 87, 91
          content flow tags, 87, 90-91
          form tags, 88, 95-101
          list tags, 87, 91-92
          structural tags, 87-88
          table tags, 87, 93-94
          text formatting tags, 87, 89-90
    text cartridge, 18-19
    text item, WebDB dashboard, 62
    TIFF format, 19
    TOAD, PL/SQL, 130-131
    top-down design, 104
    traditional filesystems, 8
    traditional relational data, 2
    trigger wizard, WebDB, 56
    TXT format, 27
    type wizard, WebDB, 56

    U[ Top ]
    UI templates library, 60
    Unix, 6, 29
    URLs, 5-6
          path, 31
          port, 31
          protocol, 31
          query string, 32
          resolution, 34
          resource name, 31
          server, 31
          WebDB dashboard, 62
    users, 42, 53

    V[ Top ]
    values, assigning in PL/SQL, 114-115
    variables, declaring in PL/SQL, 113-114
    vc_arr data structure, OWA_TEXT package, 139
    VERIFY_VALUES procedure, OWA_OPT_LOCK package, 158, 160
    Video Information Retrieval (VIR) cartridge, 18-19
    videos, 2, 19
    view wizard, WebDB, 57
    view_message procedure, FORUM package, 209-210
    view_results procedure, EMP_SURVEY package, 190-192
    VIR (Video Information Retrieval cartridge), 18-19
    virtual directories, 70, 73-74
    virtual machine, 30
    Virtual Reality Modeling Language
    (VRML), 28
    Visual Basic, 16
    VMS, 6

    W[ Top ]
    WAN (wide area network), 3, 27
    WAV format, 19, 27
    web applications, designing
          anonymous surveys example, 183-193
          data models, creating, 182
          development options, evaluating, 180-181
          discussion forum example, 193-213
          PL/SQL packages, using, 183
          storyboards, creating, 181-182
    web management, content driven, 14
    Web Request Broker (WRB)
          cartridges, 76-77
          WRB dispatcher, 77-78
          WRB Executable Engines (WRBX), 77
    web sites, tracking changes, 5-6
    WebAlchemy, 136-137
    WebDB, 9, 14
          application development, 54-61
                custom components, building, 60
                database objects, building, 55
                shared components, building, 58-60
                user interface components, building, 57-58
                wizards, 56-57
          content-driven web site management, 61-65
                access to content, controlling, 64-65
                managing content, 63-64
                user-uploaded content, 62-63
          database access descriptor (DAD), 66-68
                configuration file, 68
                parameters, 66-68
          database administration, 51-54
                browsing database objects, 52
                monitoring performance, 53-54
                security, 53
          HTTP listener, 68-71
                configuration file, 70-71
                MIME type mappings, 70
                server settings, 69
                virtual directory mappings, 69-70
          introduction, 50-51
          PL/SQL gateway, 66
    wizards, WebDB, 14, 54-57
    Word files, 10
    WordPerfect, 19
    World Wide Web, origins, 1
    WRB dispatcher, 77-78
    WRB Executable Engines (WRBXs), 77

    X[ Top ]
    XML (Extensible Markup Language), 2, 9, 12-13, 214-228
          document type definition (DTD), 219-221
          generating invoices from Oracle, 221-226
          i FS (Internet File System), 227-228
          motivations for using, 216-217
          parsers, 221
          PLSXML utilities and demos, 226-227
          syntax, 217-219
    XML_INVOICE_PKG, 221-226
          get_attribute function, 222-223
          print_invoice procedure, 225-226
          print_items procedure, 222, 224-225
          print_xml_tag procedure, 222-224

    
    

    Return to Oracle Web Applications: PL/SQL Developer's Intro