BI Publisher multiple select parameters in Function
Hi, I have a requirement to have multiple select parameters on a BI Publisher report. I am passing the parameters to a function that turns a comma separated list of values to a table.
The function works fine when I run it in Toad. The :type variable accepts multiple values.
SELECT * FROM TABLE(FN_GET_ROWS ( :date_ini, :date_end, :type));
The problem is that seems when BI Publisher passes the parameter :type it interprets each comma as a separate parameter so I get an invalid number of parameters error.
If select a value not error, and then select two values of an error: ORA-06553: PLS-306: wrong number or types of arguments in call to 'FN_GET_ROWS'