OraFAQ Forum: SQL & PL/SQL » Error : ORA-01756: quoted string not properly terminated , when v insert

Home » SQL & PL/SQL » SQL & PL/SQL » Error : ORA-01756: quoted string not properly terminated , when v insert

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

Error : ORA-01756: quoted string not properly terminated , when v insert [message #247828]

Wed, 27 June 2007 05:47

jeeva07
Messages: 7
Registered: June 2007

Junior Member

hi guru's,
pls clarify my error when i give this insert query i get this error wht is wrong in the query shown below,

INSERT INTO DD_HDR VALUES('122-65',27-JUN-07,'G','gg infotech,germany','gg1',
NULL,NULL,NULL,NULL,'11111',18-JUN-07,'O','SHI046',27-JUN-07,943,'N','01','NA','NA','NA','NA',
'@16.48% Will be Charged Extra As Shown Above','VAT@12.5% Will be Charged Extra As Shown Above',NULL,
NULL,'PR NO:125 DT : 18-JUN-07',NULL,'DIRECT','ROAD',NULL,
'4 TO 5 WEEKS AFTER CONFIRMATION',NULL,NULL,NULL);

in that query 34 columns are there and only one number(943) value and all other varchar2 and date data types.

regards,
jeeva

[Updated on: Wed, 27 June 2007 05:54]

Report message to a moderator

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

Wed, 27 June 2007 05:52

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I notice that values like 27-JUN-07 are missing quotes. If they are DATEs (but you said they weren't), you would also use TO_DATE to transform them to actual dates.

MHE

Report message to a moderator