REGEXP_LIKE and "{" and ?ParameterList?

[SPI33]

Hi everybody,
I'm looking for the way to filter a report with the REGEXP_LIKE oracle function implemented with a list of patameters coming from a prompt
My problem is : To use the REGEXP_LIKE function, I have to "protect" the filter expression by "{" (example : {regexp_like(FAMILLES,''||replace('||?listCrText?||',';','^*|*')||'')}) but the list of parameters is not well valued probably because of the "{".
I tried to "cheat" with various combination like: {regexp_like(FAMILLES,''||replace(}||?listCrText?||{,';','^*|*')||'')} but it doesn't work.
Any idea ?
Thanks for your help.

 

[SPI33]

Here is a solution recommended by IBM :

http://www-01.ibm.com/support/docview.wss?uid=swg21341806

To get the list of parameters coming (PromptName) from the prompt in the SQL Statement, you have to call the prompt via a macro : #prompt('PromptName')#

Example :
SELECT Field1, Filed 2
FROM MyTable
WHERE regexp_like(Field1,''||replace(#prompt('PromptName')#,';','^*|*')||'')

It works with 10.2