OraFAQ Forum: SQL & PL/SQL » ORA-01756: quoted string not properly terminated

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01756: quoted string not properly terminated

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01756: quoted string not properly terminated [message #194742]

Mon, 25 September 2006 01:15

rajuakula
Messages: 63
Registered: March 2005

Member

I have table1

id
description

insert into table1(id,description) values
(1,'xyz's and abc's');

getting the following error

ORA-01756: quoted string not properly terminated

thanks

Report message to a moderator

Re: ORA-01756: quoted string not properly terminated [message #194743 is a reply to message #194742]

Mon, 25 September 2006 01:19

Liza79
Messages: 74
Registered: September 2006

Member

rajuakula wrote on Mon, 25 September 2006 01:15

insert into table1(id,description) values
(1,'xyz's and abc's');

Try this

insert into table1(id,description) values
(1,'xyz''s and abc''s');

its not a double quotation mark, its the single quotation mark two times. Smile

Liza

[Updated on: Mon, 25 September 2006 01:20]

Report message to a moderator

Previous Topic:	How to Grant CONNECT only privleges to user?
Next Topic:	Global variable

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 05:47:36 CST 2024