KumarRahul605332

How to call a Oracle stored procedure in uc4

Discussion created by KumarRahul605332 on Nov 30, 2015
Latest reply on Dec 1, 2015 by KumarRahul605332
Hi All,

I have to execute a Oracle stored procedure from uc4 v9A. For this I first installed  a Oracle agent in Uc4 QA and Prod. I am able to make a connection to the db and also able to execute the command "Select * from Dual". I also got the prompt that SQL_EXECUTE_JOB will only work with SQL db and not with Oracel. So  I tried the below command to execute the stored procedure but keep getting the error Invalid sql statement. Please help.
Execute procedure_name

Thanks,
Kumar

Outcomes