COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: Wild Klaus on 02 Sep 2008 01:53:09 AM

Title: pass multiple values to a ORACLE stored procedure
Post by: Wild Klaus on 02 Sep 2008 01:53:09 AM
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.
Title: Re: pass multiple values to a ORACLE stored procedure
Post by: grom on 20 Oct 2011 04:03:04 AM
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 ?