A script-enabled browser is required for this page to function properly.

Define Text Query dialog box

The Define Text Query dialog box enables you to choose the text pluggable data source for your query. Note that, to use your Text PDS, you must configure the textpds.conf file located in your ORACLE_HOME/reports/conf directory.

Object

Description

Data Definition

Lists the formats you can choose for your Text data source. The formats listed here are registered in the textpds.conf file.

Data Source

Lists the Text pluggable data sources you can use in your query. You can either select the actual file, located in a directory, or point to a URL where the Text PDS is located.

All referenced parameters in a URL should be wrapped as follows: &<parameter>

For example, the following URL references a parameter called stock_symbol:

http://host.domain.com/vdir/get_stock_quote.jsp?symbol=&<stock_symbol>

If stock_symbol was not inside the angle brackets, the ampersand (&) would be read as an argument separator and stock_symbol as a report parameter.


Note: For a detailed example of using the Text PDS, see the chapter titled "Building a Report with a Text Pluggable Data Source" in the Oracle Reports Building Reports manual, available on the Oracle Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html).

See also

About the Text pluggable data source

Setting up the Text PDS configuration file

Creating a Text data source query using the Report Wizard

Creating a Text data source query manually