in reply to Oracle SQL syntax error (was: I can't see the error?)

You don't have to escape the (), but you might have to escape "" sometimes. Are you using perl variables inside the query or is it just that?

In Section Seekers of Perl Wisdom