Hi everybody,

I want to pass a list of parameters to a stored procedure and I don't
know how to. Can you help?

My stored procedure is like this:
.. SELECT r1 FROM t1 WHERE x1 = n1 INTO :r;

I want to change it to something like this:
.. SELECT r1 FROM t1 WHERE x1 IN (n1,n2,n3,n4,n5) INTO :r;

Is there a way?
What variable do I need to declare as a parameter for the parameters
in side of the paranthesis?

Thank you