Search list(list of values) for a search parameter in Oracle BI Publisher (10g) 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. Using a bind variable in the list of values for menu parameters works fine. Is it an issue regarding BI Publisher https://goo.gl/DcT9HB or what should I do to refresh a search list by listening to another parameter? Edit: LOV codes for the search parameter select col1|| ' - ' || col2 as item from table --search works on applying no filter select col1|| ' - ' || col2 as item from table where col3 = substr(:I_col3_param, 0, instr(:I_col3_param,'-')-2)) -- search doesn't work on applying this filter The first query will obviously return larger number of data but its search time is lesser than that of second query. So, the problem should not be due to huge amount of data.
