Before you use a Text pluggable data source, you might want to examine the text file by opening it in a text editor first to see what it looks like.
Accessing a Text data source does not require any database connection information as required for SQL queries.
To create a Text query using the Report Wizard:
First, set up the Text PDS configuration
file (textpds.conf
) with your text file's format information.
Launch Reports Builder.
Tip: If Reports Builder was already open when you modified
the textpds.conf
file, you must shut down Reports Builder and
restart it for Reports Builder to recognize your text file as a valid data
source.
In the Welcome dialog box, select Use the Report Wizard, then click OK.
If the Welcome page displays, click Next.
On the Report Type page, select Create Paper Layout only, then click Next.
On the Style page, type a title for your report and select the desired report style, then click Next.
On the Data Source page, click Text Query, then click Next.
On the Data page, click Query Definition to display the Define Text Query dialog box.
If you get an error message and cannot display the Define Text Query dialog
box, check your configuration file (textpds.conf
) to confirm
the code you added.
In the Define Text Query dialog box, under Data Definition, select
the format for your Text data source. The formats listed here are registered
in the textpds.conf
file.
Under Data Source, click Browse to find the file for the Text PDS, or type a URL where the Text PDS is located in the Location field.
Click OK to close the dialog box and display your Text query in the Data Source definition field on the Data page of the Report Wizard.
Follow the Report Wizard to complete your report definition.
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
).
About the Text pluggable data source
Creating a Text data source query manually
Copyright © 1984, 2005, Oracle. All rights reserved.