BI Publisher (MOSC)

MOSC Banner

BI Publisher multiple select parameters in Function

edited Jun 30, 2015 12:23PM in BI Publisher (MOSC) 5 commentsAnswered ✓

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'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center