Focal Point
[CASE OPEN]How to call a oracle stored procedure with parameters inside a flow in IIT

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/2947086476

February 11, 2015, 04:28 PM
Mary
[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.


7.7.04M, Windows 7 , HTML, PDF,EXCEL