Oracle SQL syntax, like most, requires a wild card to accurately use a LIKE
% is a wild card that means zero or more characters
_ is a wild card that means one (and only one) character
col1 LIKE ‘ABC%’
would search col1 looking for values that start with ABC, whether anything follows or not.
WHERE col1 LIKE ‘%ABC’
searches col1 for values that end with ABC, whether anything come before it or not
WHERE col1 LIKE ‘_ABC%’
searches for values that have ABC beginning in the second position, whether anything follow or not
WHERE col1 LIKE ‘%ABC%’
searches for ABC anywhere in col1
In your case, you will need to have one or more wild cards in your host variable.
I hope this helps.