Re: Oracle Update failed with single quotes in the data

Are you passing your data by literals or by bind variables?

If literals: that is defined behaviour of the parser. You have to double your apostrophes. Example: instead of "update foo set bar = 'Harper's'" you have to issue the command "update foo set bar = 'Harper''s'" or "update foo set bar = 'Harper' || chr (39) || 's'".

If bind variables: can you please post the code snippet?

Martin Received on Sun Nov 26 2000 - 11:00:14 CST