Oracle developer's guide

Contents......Page 3
Send Us Your Comments......Page 23
Audience......Page 25
Organization......Page 26
Related Documentation......Page 28
Conventions......Page 29
Documentation Accessibility......Page 34
Features Introduced in Oracle XML Developer\'s Kit 10g Release 1 (10.1)......Page 37
Introducing Oracle XML Developer\'s Kit......Page 41
Overview of Oracle XDK Components......Page 43
XDK Functionality Applied to XML Documents......Page 44
XML Parsers......Page 45
JAXB and C++ Class Generators......Page 46
XSLTransformer......Page 47
Oracle XML SQL Utility (XSU) for Java......Page 48
Soap Services......Page 49
XML Document Structure: Columns Are Mapped to Elements......Page 50
XSU Generates a DTD Based on Queried Table\'s Schema......Page 51
Using Oracle XDK Java Components to Generate XML Documents......Page 52
Using Oracle XDK C Components to Generate XML Documents......Page 54
Using Oracle XDK C++ Components to Generate XML Documents......Page 56
XDK and Application Development Tools......Page 58
Oracle Data Provider for .NET......Page 60
JDeveloper......Page 61
User Interface XML (UIX)......Page 63
Recommended Books and Web Sites About XML......Page 64
Information for Using the XDK......Page 65
SQL*Loader and Nesting in XML Documents......Page 66
Using Oracle Database Version 7 and XML......Page 67
B2B Standards and Development Tools that Oracle Supports......Page 68
Oracle Corporation\'s Plans for XML Query......Page 69
Maximum Size for an XML Document for PL/SQL......Page 70
XDK Java Components Specifications......Page 71
DOM Specifications......Page 72
XSL Transformations Specifications......Page 73
Installing XDK Java Components......Page 74
XDK Java Components Directory Structure......Page 75
UNIX Environment Settings for XDK Java Components......Page 76
Windows Environment Settings for XDK Java Components......Page 77
Servlet Engines......Page 78
JDBC Drivers and Databases......Page 79
Setting Up Your Servlet Engine to Run XSQL Pages......Page 80
OracleAS Oracle Containers for Java (OC4J) Servlet Container......Page 81
Apache/JServ 1.0 or 1.1......Page 83
Jakarta Tomcat 3.1 or 3.2......Page 84
XDK Java Components Dependencies......Page 88
Verifying the XDK Java Components Version......Page 89
XML Parser for Java Overview......Page 91
Namespace Support......Page 93
XML Parser for Java Validation Modes......Page 94
Enabling DTD Caching......Page 96
Recognizing External DTDs......Page 97
Parsing a DTD Object Separately from an XML Document......Page 98
About DOM and SAX APIs......Page 99
SAX: Event-Based API......Page 100
DOM......Page 101
About XML Compressor......Page 102
XML Serialization and Compression......Page 103
Running the Sample Applications for XML Parser for Java......Page 104
Without DTD Input......Page 106
With a DTD Input......Page 107
Comments on Example 1: DOMSample.java......Page 108
XML Parser for Java Example 1: DOMSample.java......Page 109
XML Parser for Java Example 2: Parsing a URL — DOMNamespace.java......Page 112
Using XML Parser for Java: SAXParser Class......Page 113
XML Parser for Java Example 3: Using the Parser and SAX API (SAXSample.java)......Page 116
XML Parser for Java Example 4: (SAXNamespace.java)......Page 120
Using the XML Parser for Java......Page 124
Using the XMLNode.selectNodes() Method......Page 125
Generating an XML Document from Data in Variables......Page 126
DOM Exception WRONG_DOCUMENT_ERR on Node.appendChild()......Page 127
Extracting PAYLOAD to do Extra Processing......Page 128
Writing an XML File in UTF-8......Page 129
Writing Parsing XML Stored in NCLOB with UTF-8 Encoding......Page 130
Storing Accented Characters in an XML Document......Page 131
General Questions About XML Parser for Java......Page 132
Including an External XML File in Another XML File......Page 133
Parsing XML from Data of Type String......Page 134
The XML Parser for Java Does Not Need a Utility to View the Parsed Output......Page 135
Generating an XML Document Based on Two Tables......Page 137
Using JAXP......Page 139
oraxml: XML Parser for Java Command-line......Page 140
XSLT Processor for Java Overview......Page 143
Using XSLT Processor for Java......Page 144
XSLT Processor for Java Example......Page 146
XSLT Command-Line Interface: oraxsl......Page 148
XML Extension Functions for XSLT Processing......Page 149
XML Parser for Java - XSL Example 1: Static function......Page 150
Return Value Extension Function......Page 151
XML Parser for Java - XSL Example 4: Datatype Extension Function......Page 152
Example of Use of Oracle XSL Extensions......Page 153
Example: Using importNode() from DOM Level 2......Page 156
Example: demo2.xml......Page 157
Example: demomerge.xsl......Page 158
Support of Output Method \"html\" in the XSL Parser......Page 159
Keeping White Spaces in Your Output......Page 160
Disabling Output Escaping Is Supported......Page 161
What Are DTDs?......Page 163
Comparison of XML Schema Features to DTD Features......Page 164
XML Schema Processor for Java Features......Page 166
Requirements to Run XML Schema Processor for Java......Page 167
XML Schema Processor for Java Usage......Page 168
Using the XML Schema API......Page 169
XML Schema Processor for Java Sample Programs......Page 170
What Is JAXB?......Page 173
Unmarshalling, Marshalling, and Validating Using JAXB......Page 174
JAXB Class Generator Command-Line Interface......Page 175
JAXB Compared with JAXP......Page 176
7 XML SQL Utility (XSU)......Page 179
XSU Features......Page 180
XSU Dependencies and Installation......Page 181
Installing XSU......Page 182
XML SQL Utility in the Database......Page 183
XML SQL Utility in the Middle Tier......Page 184
XML SQL Utility in a Web Server......Page 185
Default SQL-to-XML Mapping......Page 186
SQL-to-XML Mapping Against Object-Relational Schema......Page 187
Customizing the Generated XML: Mapping SQL to XML......Page 189
Mapping Customizations......Page 190
Default XML-to-SQL Mapping......Page 191
Inserting with XSU......Page 192
Updating with XSU......Page 193
Using the XSU Command-Line Front End OracleXML......Page 194
XSU\'s OracleXML getXML Options......Page 195
Inserting XML Using XSU\'s Command Line (putXML)......Page 197
XSU OracleXML putXML Options......Page 198
Generating XML with XSU\'s OracleXMLQuery......Page 199
XSU Generating XML Example 1: Generating a String from Table employees (Java)......Page 200
XSU Generating XML Example 2: Generating DOM from Table employees (Java)......Page 203
When the Number of Rows or Columns in a Row Is Too Large......Page 205
XSU Generating XML Example 3: Paginating Results: (Java)......Page 206
XSU Generating XML Example 4: Generating XML from JDBC ResultSets (Java)......Page 207
XSU Generating XML Example 5: Generating XML from Procedure Return Values......Page 209
XSU Generating XML Example 6: No Rows Exception (Java)......Page 211
Storing XML Back in the Database Using XSU OracleXMLSave......Page 212
XSU Inserting XML Example 7: Inserting XML Values into All Columns (Java)......Page 213
XSU Inserting XML Example 8: Inserting XML Values into Columns (Java)......Page 215
XSU Updating XML Example 9: Updating a Table Using the keyColumns (Java)......Page 216
XSU Updating XML Example 10: Updating a Specified List of Columns (Java)......Page 217
Delete Processing Using XSU (Java API)......Page 218
XSU Deleting XML Example 12: Deleting Specified Key Values (Java)......Page 219
XSU Exception Handling in Java......Page 220
OracleXMLNoRowsException Class......Page 221
Schema Structure to use with XSU to Store XML......Page 222
XSU and COMMIT After INSERT, DELETE, or UPDATE......Page 224
Mapping Table Columns to XML Attributes Using XSU......Page 225
XSQL Pages Publishing Framework Overview......Page 227
What Can I Do with Oracle XSQL Pages?......Page 228
What Is Needed to Run XSQL Pages?......Page 230
Disable Default Client Stylesheet Overrides......Page 231
What\'s New in XSQL Pages Release 10.1......Page 232
Producing XML Datagrams from SQL Queries......Page 234
Transforming XML Datagrams into an Alternative XML Format......Page 237
Transforming XML Datagrams into HTML for Display......Page 241
Using XSQL Pages with Oracle JDeveloper......Page 243
Setting the CLASSPATH Correctly in Your Production Environment......Page 244
Setting Up the Connection Definitions......Page 245
Using the XSQL Command-Line Utility......Page 246
The  Action......Page 247
The  Action......Page 251
The  Action......Page 252
Using Bind Variables......Page 253
Using Lexical Substitution Parameters......Page 255
Providing Default Values for Bind Variables and Parameters......Page 256
Understanding the Different Kinds of Parameters......Page 258
The  Action......Page 259
The  Action......Page 260
The  Action......Page 261
The  Action......Page 262
The  Action......Page 264
The  Action......Page 265
The  Action......Page 267
Working with Array-Valued Parameters......Page 269
Setting Array-Valued Page or Session Parameters from Strings......Page 270
Binding Array-Valued Parameters in SQL and PL/SQL Statements......Page 271
Supplying Multi-Valued Parameters on the Command Line......Page 274
Conditionally Executing Actions or Including Content with ......Page 275
Optionally Setting an Error Parameter on Any Built-in Action......Page 277
Aggregating Information Using ......Page 278
Including XMLType Query Results......Page 280
Handling Posted Information......Page 283
Understanding Different XML Posting Options......Page 287
Using Custom XSQL Action Handlers......Page 289
Description of XSQL Servlet Examples......Page 290
Setting Up the Demo Data......Page 292
Using a Custom XSQL Configuration File Name......Page 293
Understanding Client Stylesheet-Override Options......Page 294
Controlling the Content Type of the Returned Document......Page 295
Assigning the Stylesheet Dynamically......Page 296
Processing Stylesheets in the Client......Page 297
Providing Multiple, UserAgent-Specific Stylesheets......Page 298
Using XSQL Configuration File to Tune Your Environment......Page 300
Using the FOP Serializer to Produce PDF Output......Page 310
Using XSQL Page Processor Programmatically......Page 312
Writing Custom XSQL Action Handlers......Page 314
Writing your Own Action Handler......Page 317
Writing Custom XSQL Serializers......Page 321
Using a Custom XSQL Connection Manager for JDBC Datasources......Page 325
Writing Custom XSQL Connection Managers......Page 326
Providing a Custom XSQLErrorHandler Implementation......Page 327
Providing a Custom XSQL Logger Implementation......Page 328
XSQL Servlet Limitations and Hints......Page 330
Writing XSQL Servlet Conditional Statements......Page 331
Using the XSQL Servlet to Access the JServ Process......Page 332
Handling Multi-Valued HTML Form Parameters......Page 333
Out Variable is not Supported in ......Page 334
Receiving \"Unable to Connect\" Errors......Page 335
XSQL Supports SOAP......Page 336
Accessing Authentication Information in a Custom Connection Manager......Page 337
Resolving Errors When Using the FOP Serializer......Page 338
Combining JavaServer Pages and XSQL in the Same Page......Page 340
Sorting the Result Within the Page......Page 341
Using Pipeline Definition Language......Page 343
Example of a Pipeline Definition Language Application......Page 344
The Command-line Pipeline Tool orapipe......Page 349
Accessing Oracle XDK JavaBeans......Page 351
XSLTransformer......Page 352
DOMBuilder JavaBean......Page 353
DOMBuilder JavaBean Usage......Page 354
XSLTransformer JavaBean: Regenerating HTML Only When Data Changes......Page 356
How to Use XSLTransformer JavaBean......Page 357
DBAcess JavaBean Usage......Page 358
XMLDiff JavaBean......Page 359
JavaBean Examples......Page 360
Installing the JavaBean Examples......Page 361
XMLDiffSample.java......Page 362
XSDValidatorSample.java......Page 363
What Is SOAP?......Page 365
What Are UDDI and WSDL?......Page 366
How Does Oracle SOAP Work?......Page 367
Oracle SOAP and IDAP......Page 368
SOAP Client API......Page 369
SOAP Transports......Page 370
SOAP Services Provided......Page 371
SOAP Example......Page 372
XML Features Used in the SOAP Example......Page 373
How Is the SOAP Example Implemented?......Page 374
Setting Up the Tables and the SOAP Service......Page 376
Initializing the MessageDispatcher Process......Page 377
Enqueuing the XML Document......Page 378
Listing of the Java Source File inserItemServlet.java......Page 379
XML Compression......Page 383
Summary of the SOAP Example......Page 384
Overview of the TransX Utility......Page 385
Simplified Data Format Support and Interface......Page 386
Other TransX Utility Features......Page 387
Installing TransX Using the Oracle Installer......Page 388
TransX Utility Command-Line Examples......Page 389
TransX Utility Command-line Options......Page 390
Sample Code for TransX Utility......Page 391
Specifications of XDK C/C++ Components......Page 393
Installing the C Components of XDK......Page 394
Command Line Environment Setup......Page 395
Setting the Windows Environment......Page 397
Environment for Command Line Usage......Page 398
Using the XDK C Components with Visual C++......Page 400
Globalization Support for the C XDK Components......Page 406
What Is the Unified C API for XDK and Oracle XML DB?......Page 409
Using DOM for XDK......Page 410
Data Encoding of XML Documents for the C API......Page 411
NULL-Terminated and Length-Encoded C API Functions......Page 412
Installing the C API......Page 413
Creating XMLType Instances on the Client......Page 414
XMLType Functions and Descriptions......Page 415
OCI Examples......Page 416
Using the XML Parser for C......Page 420
Data Types Index......Page 421
XML Parser for C Calling Sequence......Page 422
Parser Calling Sequence......Page 423
XML Parser for C Default Behavior......Page 424
DOM and SAX APIs Compared......Page 425
Command Line Usage......Page 426
Using the Sample Files......Page 427
XVM Processor......Page 431
XVM Usage Example......Page 432
Command-Line Access of the XVM Processor......Page 433
XSL Processor Usage Example......Page 434
XPath Processor Usage Example......Page 435
Command Line Usage of the XSL Processor......Page 436
Using the Demo Files Included with the Software......Page 437
Building the C Demo Programs for XSLT......Page 438
Oracle XML Schema Processor for C......Page 439
XML Schema Processor for C: Supplied Software......Page 440
XML Schema Processor for C Usage Diagram......Page 441
How to Run XML Schema for C Sample Programs......Page 442
Getting the C++ Components of XDK......Page 445
Libraries in the UNIX Environment for C++ XDK......Page 446
Setting the UNIX Environment for C++......Page 447
Windows Environment Setup for C++ XDK......Page 448
Setting the Windows Environment for C++ XDK......Page 449
Using XDK C++ Components with Visual C++......Page 451
What is the Unified C++ API?......Page 457
OracleXML Namespace......Page 458
Ctx Interfaces......Page 459
IO Interfaces......Page 460
Error Message Files......Page 461
Introduction to Parser for C++......Page 463
Dom Namespace......Page 464
DOM Interfaces......Page 465
DOM Traversal and Range Interfaces......Page 466
SAXParser Interface......Page 467
XML Parser for C++ Default Behavior......Page 468
C++ Sample Files......Page 469
Accessing XSLT for C++......Page 471
XSLT for C++ DOM Interface Usage......Page 472
Using the Sample Files Included with the Software......Page 473
Oracle XML Schema for C++ Features......Page 475
Invoking XML Schema Processor for C++......Page 476
Running the Provided XML Schema for C++ Sample Programs......Page 477
XPath Interfaces......Page 479
Sample Programs......Page 480
Using XML C++ Class Generator......Page 481
XML C++ Class Generator Usage......Page 482
Using the XML C++ Class Generator Examples......Page 483
XML C++ Class Generator Example 2: DTD — Input File to Class Generator, CG.dtd......Page 484
XML C++ Class Generator Example 3: CG Sample Program......Page 485
XSU PL/SQL API......Page 489
XSU Generating XML Example 1: Generating XML from Simple Queries (PL/SQL)......Page 490
XSU Generating XML Example 3: Changing ROW and ROWSET Tag Names......Page 491
XSU Generating XML Example 4: Using setMaxRows() and setSkipRows()......Page 492
Binding Values in XSU (PL/SQL)......Page 493
XSU Generating XML Example 5: Binding Values to the SQL Statement......Page 494
Storing XML in the Database Using DBMS_XMLSave......Page 495
XSU Inserting XML Example 6: Inserting Values into All Columns (PL/SQL)......Page 496
XSU Inserting XML Example 7: Inserting Values into Certain Columns (PL/SQL)......Page 497
Update Processing Using XSU (PL/SQL API)......Page 498
XSU Updating XML Example 9: Specifying a List of Columns to Update (PL/SQL)......Page 499
XSU Deleting XML Example 10: Deleting Operations for Each Row (PL/SQL)......Page 500
XSU Example 11: Deleting by Specifying the Key Values (PL/SQL)......Page 501
XSU Deleting XML Example 12: Reusing the Context Handle (PL/SQL)......Page 502
XSU Exception Handling in PL/SQL......Page 503
Glossary......Page 505
C......Page 531
D......Page 532
I......Page 533
M......Page 534
P......Page 535
S......Page 536
X......Page 537