Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting a 'missing or illegal' character error using the escape clause

Stanley Lee-OracleMar 24 2011 — edited Mar 24 2011
Hi,

I have been using this query for awhile in my trigger and it works fine until now.

SELECT count(*) from TABLE where NAME like NEW.ID || '\_%' escape '\'

For one of the NEW.ID values, it doesn't exist on the table and I get this error:

ORA-01424: missing or illegal character following the escape character

Thanks.

Edited by: Samantha on Mar 24, 2011 4:39 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2011
Added on Mar 24 2011
3 comments
604 views