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: 64132
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: INDEX
Next Topic: Oracle/PL/SQL runtime errors.
Goto Forum:
  


Current Time: Wed Dec 07 22:26:44 CST 2016

Total time taken to generate the page: 0.06654 seconds