To create a JDBC query:
In the Data Model view, single-click
in the tool palette.
Click in the main area (canvas region) of the window.
In the JDBC Query dialog box, define the JDBC query or procedure and the connection parameters for the data source. Click Help for assistance.
Click Connect to display the Connect dialog box.
In the Connect dialog box, enter your user name, password and database name, choose the Driver Type you want to use, then click Connect.
In the JDBC Query dialog box, click OK to close the dialog box and
display your new query in the
Data Model view.
The JDBC PDS section of the online Help
"Configuring and Using the JDBC PDS" in OracleAS
Reports Services Publishing Reports to the Web, available on the Oracle
Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html
)
Creating a query: SQL Query tool
Creating a query: XML Query tool
Creating a query: Text Query tool
Creating a query: Express Server Query tool
Creating a query: OLAP Query tool
Creating a query: Ref Cursor Query tool
Copyright © 1984, 2005, Oracle. All rights reserved.