Home » SQL & PL/SQL » SQL & PL/SQL » Error : ORA-01756: quoted string not properly terminated , when v insert
Error : ORA-01756: quoted string not properly terminated , when v insert [message #247828] Wed, 27 June 2007 05:47 Go to next message
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 Go to previous messageGo to next message
Maaher
Messages: 7062
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
Re: ORA-01756: quoted string not properly terminated [message #247834 is a reply to message #247830] Wed, 27 June 2007 05:57 Go to previous messageGo to next message
jeeva07
Messages: 7
Registered: June 2007
Junior Member
with out using To_date() how to to insert one date on that query sir?
Re: ORA-01756: quoted string not properly terminated [message #247835 is a reply to message #247834] Wed, 27 June 2007 06:07 Go to previous messageGo to next message
jeeva07
Messages: 7
Registered: June 2007
Junior Member
When i give to_date() for date, again i got the same error ....
Re: Error : ORA-01756: quoted string not properly terminated , when v insert [message #247849 is a reply to message #247828] Wed, 27 June 2007 06:37 Go to previous messageGo to next message
jeeva07
Messages: 7
Registered: June 2007
Junior Member
thank you maahar , i got the answer. that query working now... that date only error.. thanks,bye.
Re: Error : ORA-01756: quoted string not properly terminated , when v insert [message #247867 is a reply to message #247849] Wed, 27 June 2007 07:07 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
You're welcome. Thanks for the feedback.

MHE
Previous Topic: Ref cursor
Next Topic: Can not send mail thru pl/sql
Goto Forum:
  


Current Time: Fri Dec 09 17:34:49 CST 2016

Total time taken to generate the page: 0.32127 seconds