trying to pass parm to SQL statement in a plsql proc using wildcard escape characters ...

CREATE OR REPLACE PROCEDURE ORASYSAD.P_DES_META (var2 in varchar2,

whatever --------------------

I am trying to pass the input parm var2 to a SQL statement like below ..  I am geting a ORA-00911: invalid character

and (col.name like ''%'||var2||'%'\_%' escape '\' or col.name like '%\_'%'||var2||'%'' escape '\' )any help appreciated ..