search cancel

Can CA WA ESP Edition directly call a PL/SQL procedure>

book

Article ID: 200557

calendar_today

Updated On:

Products

ESP Workload Automation

Issue/Introduction

We are planning to create some PL/SQL procedures to be executed directly on the database. 

Is there a functionality within ESP to directly call a PL/SQL procedure and execute it in the specific database? Or do we need to use a wrapper shell script (that would call PL/SQL internally) for the ESP Job Definition?

Can we use the Database plug-in for this?

Environment

Release : 11.4 & 12.0

Component : CA ESP WORKLOAD AUTOMATION,

Release : 11.4 & 12.0
CA Workload Automation System Agent, CA Workload Automation Database Agent

Resolution

ESP can't call PL/SQL procedure directly. You can use the wrapped shell script or database agent. The database agent plugin supports SQL job type, you can run the PL/SQL in the SQL job type. SQL job type will support any statement that DB understands.