How to call a oracle stored procedure

[tempra]

Hi there,

I am trying to find out on how to call a oracle stored procedure but no success yet. I have already load the procedure definitions into the data manager, but I don't know how to call it from a stage (oci9i). Do you guys have any idea about how to achieve this?

Cheers,

Melquior

 

[vmcburney]

Try user-defined SQL with something like the following:

call ProcedureName 1, :2)

Values :1 and :2 get bound to the stage input columns.