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

[apriydar]

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

[Shaun Roberts]

Use the "Execute SQL Server SQL Script"

use the SQL command

EXEC

[apriydar]

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.

[Shaun Roberts]

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.