Home » SQL & PL/SQL » SQL & PL/SQL » Help can't get this to work
Help can't get this to work [message #335698] Wed, 23 July 2008 05:39 Go to next message
Nazir666
Messages: 2
Registered: July 2008
Junior Member
For some reason the below code is just not working and i don't know why maybe someone might notice what is wrong and thanks.

insert into title(title_id,title,description,rating,category,release_date)
values(title_id_seq.NEXTVAL, 'Willie and Christmas Too', 'All of Willie's friends make a Christmas list for Santa, but Willie has yet to add his own list.','G', 'CHILD', TO_DATE('05-OCT-1995','DD-MON-YYYY')

ERROR:
ORA-01756: quoted string not properly terminated
Re: Help can't get this to work [message #335702 is a reply to message #335698] Wed, 23 July 2008 06:10 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Read the OraFAQ Forum Guide before posting.

Try Willies instead of Willie's
Re: Help can't get this to work [message #335710 is a reply to message #335698] Wed, 23 July 2008 06:57 Go to previous messageGo to next message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, I think the error message is pretty obvious: count your quotes. odd or even?

Regards
Michel
Re: Help can't get this to work [message #335726 is a reply to message #335698] Wed, 23 July 2008 07:36 Go to previous message
Nazir666
Messages: 2
Registered: July 2008
Junior Member
thanks a lot i forgot to add another ' right Willie's like Willie''s thanks a lot Smile

[Updated on: Wed, 23 July 2008 07:39]

Report message to a moderator

Previous Topic: How to retrive the latest updated records
Next Topic: Left outer joins over a HS link
Goto Forum:
  


Current Time: Sun Aug 20 05:00:40 CDT 2017

Total time taken to generate the page: 0.17403 seconds