multiple parameters to oracle Store procedure

[gbrudno]

Hi guys,

I know that passing multiple values in parameters using static list sends the parameter values in one comma seperated string like 'Usa, canada, mexico' to the stored procedure.

But if we pass multiple values in parameters using the dynamic lov coming from the Business views, does the string format looks same like above? Can such values be passed to stored proc without puting main report into subreport?

Crystal Xi R2

This array puts all parameters in the comma separated string. How to pass this in Oracle or Data Foundation or Business Element.

Any idea!!
----------------
WhilePrintingRecords;
stringvar array test:= {?Multiple_Values};
//numbervar cnt:=ubound({?Policy_PK});
numbervar i;
stringvar str; //:=test[1];
for i:=1 to count({?Multiple_Values}) do
(
if i<>count({?Multiple_Values}) then
str:=str&test&","
else
str:=str&test

//i:=i+1;
);
str;
-------------------------------

Thanks!