This discussion is archived
0 Replies Latest reply: Aug 21, 2012 1:39 AM by 936299 RSS

bind variable with search parameter in Oracle BI Publisher 10

936299 Newbie
Currently Being Moderated
Search list for a search parameter in Oracle BI EE works fine when the query doesn't contain a bind variable (parameter identifier). But when a bind variable is introduced in the constraint of search list query, it keeps on searching endlessly. For example,

-- this doesn't work
select col1
from table
where table.col2 = :I_param_bind_var

-- this works
select col1
from table
where table.col2 = 'xyz'

Using such bind variable in the list of values for menu parameters works fine. Is it an issue regarding publisher or am I missing something?

Edited by: 933296 on Aug 21, 2012 1:38 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points