BI Publisher (MOSC)

MOSC Banner

How to pass parameter from data template to bursting query

edited Feb 27, 2014 6:58AM in BI Publisher (MOSC) 18 commentsAnswered ✓

I am running BI Publisher stand alone 10.1.3.4.2. I need to add a parameter which is defined in my data template to the bursting query. My bursting query is running against an xmltable and I will get "expected singleton sequence" error without adding a where clause. Works great if I hard code the value.  When I add "where id = :parm_value",   it returns a "Data not defined" error even though parm_value is defined in the data template. Is this possible?

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