(Solved) Passing Multiple Values to Stored Proc Prompt in FM

[shank]

Guys,

How to pass multiple values to a single stored procedure prompt. For
example, for the country prompt it works fine for single value, but not
for multiple selected values like 'america','australia','china','India'
etc.,

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.

Regards,

Cognos Pal

[mrcool]

You cannot pass multiple values directly in stored procedure query
subject. Create a data source query subject then call the procedure like

exec <proc_name> #sq(promptmany('param1','char'))#
This will create a multi valued parameter param1 and it will enclose
the parameters within single quotes so that it becomes a string
variable.
In the SP you need to split this into differnt values by using a
function which returns table variable


Thanks,
Mrcool