Anyone an expert with SQL?
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.
The database sounds liek it hasnt stored the characters with slashes. a ' should be stored as a /' if i recall correctly.
Try replacing ' by '' or it might also be \'