Hi,
A parameter named in_Region declared as Collection in i-report and need to pass this parameter to Oracle stored procedure.
in I-report query this is how i call the SP :
{
call REPORT.GetStatistic(
$P{in_Region},
$P{ORACLE_REF_CURSOR}
)}
in JasperServer , i created Input Control of type Multi-Select Query (Checkbox)
and i got this error when i run in jasperserver
com.jaspersoft.jasperserver.api.JSExceptionWrapper: Report design not valid : 1. Parameter type not supported in query : in_Region class java.util.Collection
any idea?