How To Run an OWB 11g Mapping From SQL*Plus Without Involving the Control Center Service (Doc ID 1372923.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.1 to 11.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Jun-2013***

Goal

All OWB tasks like Process Flows and Mappings can be executed using the script  sqlplus_exec_template.sql. This script uses the OWB Control Center Service to manage the execution. For this reason, the Control Center Service should be "Available".

Process Flows will only run via the Control Center Service. But Mappings can be executed without the Control Center Service.

This note explains how to execute Mappings without involving the Control Center Service. It does not matter if this service is "Available" or "Not Available".

This method can be used for various reasons, such as:

In this case, the mapping can e.g. be executed from SQL*Plus. After the execution, the user can decide to COMMIT or ROLLBACK the transaction.
To be able to enable a session trace on a Mapping, it is required to know in which session the Mapping is running. However, when running a mapping with the sqlplus_exec_template.sql, a new session is spawned in the database. This makes it difficult to enable the session trace.
When executing the Mapping as described in this note, no new session is spawned for the Mapping execution. Therefore it is more suitable for session tracing. For more information on this topic, refer to:
<Document 453777.1>: How To Perform a Session Trace on Mappings In OWB 11g

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms