BI Publisher (MOSC)

MOSC Banner

XML Data Template Parameter definitions - Is it possible to pass a list of items as a parameter

edited Oct 25, 2013 8:59AM in BI Publisher (MOSC) 2 commentsAnswered ✓
I have a requirement to pass a list of items as a parameter for a BI Publisher report using the XDODTEXE executable.  Users would like to pass a list of projects on the concurrent program, so I've defined a conc pgm parm with 240 Characters as the value set.  User wants to populate freeform with a list of projects, e.g. 'ABCD', 'EFGH', 'JKLM'

Report currently allows a single project and functions properly.  Trying to modify to allow a list of projects, so that main query is something like:

select ...

from pa_projects p

where p.segment1 in (:p_project_list)

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