Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

Cisco Employee

How to execute a PL/SQL Stored procedure from CPO ?

Is there a way to execute a stored procedure from CPO, if yes then please explain how can we do that ?

  • Cisco Process Orchestrator
3 REPLIES
Cisco Employee

How to execute a PL/SQL Stored procedure from CPO ?

Use the "Execute SQL Server SQL Script"

use the SQL command

EXEC

--Shaun Roberts shaurobe@cisco.com CIAC Adoption Pilot Engineering Lead
Cisco Employee

How to execute a PL/SQL Stored procedure from CPO ?

I am using Execute Oracle SQL Scripts

My script is - EXECUTE testproc;

I get following error - ORA-00900: invalid SQL statement

However it works on TOAD.

Cisco Employee

How to execute a PL/SQL Stored procedure from CPO ?

You need to be careful you do not have an extra space around the statement or in it or something. If you need further help please open a TAC case and support can help.

--Shaun Roberts shaurobe@cisco.com CIAC Adoption Pilot Engineering Lead
378
Views
0
Helpful
3
Replies
This widget could not be displayed.