Creating a job that executes procedure from package Oracle
search cancel

Creating a job that executes procedure from package Oracle

book

Article ID: 220787

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Looking for a way to create and run a SQL job that can execute a procedure from a package in Oracle and execute in Automic.

Resolution

There was some chatter around the some time ago on our community site here (nothing should have changed between the versions they are on, version 12.x and 21.x): https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=784378

It comes down to being able to put something like this into the process tab of the SQL job:

sql_set_statement_terminator term="@";
begin
 dbms_output.enable(NULL);
 package_name.stored_procedure_name('paramter');
end;
 @

The details of this are described in the community post above.