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 manually:
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 Reports Builder, display the Data Model view.
In the Data Model view, single-click
in the tool palette.
Click in the main area (canvas region) of the window 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 new Text query in the Data Model view.
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 using the Report Wizard
Copyright © 1984, 2005, Oracle. All rights reserved.