pass multiple values to a ORACLE stored procedure

[Wild Klaus]

Hi.
Help plz, how to pass multiple values to a ORACLE stored procedure.

I used #promptmany as suggested in th FM documentation, but it is giving error message as "promptmany" not
recognized.

Could you please suggest how to achieve multiple parameter passing.

[grom]

Hello all,

We are trying to migrate some things from BO and some objects use stored procedures. So we are facing the same issue but with single passing. The stored procedure gives back the deactivation date of a contract for all contract id's selected in that query. How would you build this in FM cognos 10 ? Just copying the query is not working. We don't want to have the user prompted for every contract id they want the deactivation date.

Is it eaiest to do with a sort of pass through sql ?