[CASE OPEN]How to call a oracle stored procedure with parameters inside a flow in IIT
Hi Friends,
One of My flow need to refer a stored procedure in oracle database. I am using SQL object to call that procedure.
CALL Procedure_Name(p1,p2,p3). p1 is input parameter, p2 and p3 are out parameters.
But it fails by giving error message. Each timne it gives a different error message. The Latest one is "ORA-06576: not a valid function or procedure name".
I verified the procedure by running them in the data base and i have correct adapters to connect to the database.
I don't know what is missing and where is missing?.
Please help me solve the issue.
Thanks,This message has been edited. Last edited by: Tamra,
7.7.04M, Windows 7 , HTML, PDF,EXCEL
February 17, 2015, 07:27 PM
<Kathryn Henning>
Hi Mary,
I've been in contact with support management, and they have asked that you open a case on InfoResponse Online so that this can be reviewed further.
Thanks and regards,
Kathryn
February 19, 2015, 06:38 PM
Mary
I already opened a case and working on it. thought of getting different approaches quickly.