0 Replies Latest reply on Aug 21, 2012 8:39 AM by 936299

    bind variable with search parameter in Oracle BI Publisher 10

    936299
      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