Oracle connection

With the Oracle connection, you can retrieve data from an Oracle database using SQL statements. The SQL statements, input parameters, and output columns are all part of the entry definition.

When you run a Master Template, the Data Manager connects to an Oracle database. Specify the database to connect to in the connection configuration in KCM Core Administrator.

Requirements

To use the Unicode support, KCM requires Oracle Client 8.0 or higher.

Also, consider the following limitations when using this connection type:

• Use the SQL SELECT statement in the data and key retrieval statements.
• You cannot use stored procedures or stored functions.
• To create DID defined functions, use the UPDATE statement.
• To update the database, use formal parameters of type W_CHAR if the corresponding columns are specified as Unicode in the database.

Usage

To use this connection type, follow these steps:

1. Open the required DID document and locate a DID module that contains Oracle connection entries.

   A DID can contain multiple Oracle connection modules. However, KCM can connect to only one Oracle database at a time. You can use different databases for different DIDs and Master Templates, but not within a single DID.

2. Set the CONNECTION attribute to ORACLE.

3. To construct the SELECT part of an SQL statement, specify a column name in the DATABASE_FIELD attribute. You can rename a database column name to a KCM Field name.

   In this example, a database column named ORDNR is renamed to a Field name Order_number.

   Order_number NUMERICAL(8 0) DATABASE_FIELD "ORDNR"

The following data types are supported for Fields in the Oracle connection: C_CHAR, NUMERICAL, and W_CHAR.