Hello everybody,

I want to ask you for help. I'm trying to create a procedure with a input parameter for instance "var1". And in the procedure I'm using LIKE predicate, where I want to put the parameter in the pattern side.
Something like this:

..... WHERE r.name LIKE '%var1%' .........

but it takes var1 like a char, not like a parameter, so if you have some advices I'll be glad

Thank you all.

never concatonated a like predict
LIKE '%'||var1||'%'

but most times, I build the % within var1

Instead of LIKE you can use LOCATE function. With the same result.

Kara

Thank you all

You can use dynamic SQL to create the SQL statement, the prepare and execute it (or execute immediate).