Multiple Values Within Oracle Stored Proc Paramter

[ejg]

Hi Folks,

Does anyone know if it is possible to pass multiple values to an Oracle Stored Procedure Paramter via Crystal version reports version 7?

I have created the following procedure

(lotid in FW.fwlot.appid%TYPE,
notes in out FW.CAT_SCRAP.rctl) is
begin
open notes for
select a.serialnumber,a.location,a.partnumber,a.abckey,a.parentkey
from fwbom.abctbl a
start with abckey in (select a.abckey from fwbom.abctbl a where a.serialnumber = lotid)
connect by prior abckey = parentkey;
end CAT_ABC_PROCEDURE;

------------------------
The LOTID Parameter shows up and allows me to go into a partial edit mode. But the area that allows you to click "allow multiple values" is grayed out.

Any help would be appreciated!

regards,
ejg