Anyone an expert with SQL?

[gear02]

I have this error where if I try to enter a ' into a search box in this program, I get the following error:

java.sql.SQLException: ORA-00911: invalid character

So I'm assuming that the ' is causing it. Are ' not permitted or do you need an escape character?

Thanks guys and I'm sorry if this is the wrong forum.

[ribitch]

The database sounds liek it hasnt stored the characters with slashes. a ' should be stored as a /' if i recall correctly.

[skynet]

Try replacing ' by '' or it might also be \'