cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
948
Views
0
Helpful
3
Replies

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

apriydar
Cisco Employee
Cisco Employee

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

3 Replies 3

Shaun Roberts
Cisco Employee
Cisco Employee

Use the "Execute SQL Server SQL Script"

use the SQL command

EXEC

--Shaun Roberts
Principal Engineer, CX
shaurobe@cisco.com

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.

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
Principal Engineer, CX
shaurobe@cisco.com
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: