Name: Get the Oracle Product Banner Example
Author: Christian Berger

Version: 1.0

Created: 12/2006

Modified: 6/2007 - updated all components to 6.1.1.

Purpose: This example shows how you can use Oracle 10g's support for regular expressions from Pipeline Pilot. The query that's being executed simply selects the Oracle product banner column from v\\\$version and limits the result to rows where the banner column starts with "Oracle" or "oracle". If that query fails (e.g. if you're using an older Oracle version or a different RDBMS altogether), it will query v\\\$version in a more traditional way. If that is successful it will display that product's banner info.

Requirements: Pipeline Pilot Server 6.1.1 with the Integration collection, the 'SciTegic Oracle 5.1' driver

O/S: Any

Limitations: N/A

Keyword: oracle, odbs, integration, database

Contents: Get the Oracle Product Banner Example.xml

Installation:

1. Unzip the archive into a convenient location.
2. Import the protocol into Pipeline Pilot.
3. If you haven't done so already, set up a DSN that points to an Oracle 10 instance.
4. Fill in the required protocol parameters for the ODBC connection (ODBC DSN, ODBC Username, ODBC Password).
5. Run.