14.3 Configuring and Using XML PDS

XML PDS is configured and available out-of-the-box.

14.3.1 XML PDS Configuration File

The xmlpds.conf file is the Oracle Reports XML PDS configuration file. It is located at the following directories:

• For Reports Server:

  ORACLE_INSTANCE\config\ReportsServerComponent\server_name

• For Oracle Reports Builder:

  ORACLE_INSTANCE\config\ReportsToolsComponent\ReportsTools

• For Reports Application (in-process Reports Server) deployed in Oracle WebLogic Server: ORACLE_INSTANCE\$FMW_HOME/user_projects/domains/<domain_name>/servers/WLS_REPORTS/stage/reports/reports/configuration

Note: The only parameter that can be changes is the columnLength. The default size of the column is 4000 bytes

Example

The following example illustrates the contents of xmlpds.conf file:

<xmlpds     xmlns="http://xmlns.oracle.com/reports/pdsxml"   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   xsi:schemaLocation="http://xmlns.oracle.com/reports/pdsxml file:c:\orawin/reports/dtd/xmlpds.xsd"   >     <columnInfo>         <columnLength>4000</columnLength>     </columnInfo></xmlpds>