Yes, using the bind syntax does take care of this. There's something else going on.
First of all, Oracle 8i won't accept unquoted strings so presumably either the apostrophe's are stripped from the example he posted or bind vars are really being used.
Anyway ... Dayra, we need the actual database error you got. Assuming you did really use the bind variable syntax or typed " 'O''Riley' ".
