ORA-01756: quoted string not properly terminated

hi all,

when i am try to do this

insert into TB_DIVISION values ('MOHQ','MARK'S OFFICE');

i am getting ORA-01756: quoted string not properly terminated. apparently, the system took the quote that is in mark's as the closing quote. can anyone tell me how should i go about in order to allow such kind of insertion.

thanks in advance...

evelyn.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 25 1998 - 19:54:13 CST