Tidal Enterprise Scheduler: Execute an Oracle Stored Procedure

Available Languages

Download Options

PDF (78.9 KB)
View with Adobe Reader on a variety of devices

Updated:October 10, 2012

Document ID:113642

Bias-Free Language

The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.

Introduction

Prerequisites

Requirements

Components Used

Execute an Existing Oracle Stored Procedure

Related Information

Introduction

This document provides instructions on how to execute an Oracle Stored Procedure.

Prerequisites

Requirements

Cisco recommends that you have knowledge of these topics:

Tidal Master (Windows or Unix)
Oracle Database Adapter

Components Used

The information in this document is based on these hardware and software versions:

Tidal Enterprise Scheduler Master version 5.3.1 or higher (including 6.x versions)
Tidal Enterprise Scheduler Oracle Database Adapter

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Execute an Existing Oracle Stored Procedure

In order to execute an existing Oracle Stored Procedure from within Tidal Enterprise Scheduler, the stored procedure must have a “BEGIN” before the stored procedure and an “END;” at the end (note the semi-colon). This must all be done in one step in the Oracle Database Adapter, and not in three steps.