Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 ora-0001, oracle

Author  Topic 

Zajcica
Starting Member

22 Posts

Posted - 2013-06-17 : 12:56:24
Please!
I am adding new row!
wrote:

insert into program (c1c2...) values (v1,v2...); and am getting ora-00001.

Please, I tried to oracle forum but they are all closed...need instant help!

What might be wrong?

p.s. habe one primary key and one foreign...but this should NOT interfear, because i can use any fk_ id I want, don+t I? (in this example!)

Many thanks!

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-06-17 : 13:01:50
quote:
Originally posted by Zajcica

Please!
I am adding new row!
wrote:

insert into program (c1c2...) values (v1,v2...); and am getting ora-00001.

Please, I tried to oracle forum but they are all closed...need instant help!

What might be wrong?

p.s. habe one primary key and one foreign...but this should NOT interfear, because i can use any fk_ id I want, don+t I? (in this example!)

Many thanks!

I am not an oracle expert - but ORA-0001 appears to be a uniqueness constraint violation. Check which columns have uniqueness constraints. Then examine the data in those columns and compare with the data you are going to insert to see if there are any duplicates.
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2013-06-17 : 17:27:25
Did you try http://www.dbforums.com/oracle/ ?
Go to Top of Page

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-06-18 : 00:16:07
Here, You can see the error cause
http://www.techonthenet.com/oracle/exceptions/named_system.php

--
Chandu
Go to Top of Page

Zajcica
Starting Member

22 Posts

Posted - 2013-06-18 : 02:46:29
quote:
Originally posted by James K

quote:
Originally posted by Zajcica

Please!
I am adding new row!
wrote:

insert into program (c1c2...) values (v1,v2...); and am getting ora-00001.

Please, I tried to oracle forum but they are all closed...need instant help!

What might be wrong?

p.s. habe one primary key and one foreign...but this should NOT interfear, because i can use any fk_ id I want, don+t I? (in this example!)

Many thanks!

I am not an oracle expert - but ORA-0001 appears to be a uniqueness constraint violation. Check which columns have uniqueness constraints. Then examine the data in those columns and compare with the data you are going to insert to see if there are any duplicates.



Yes, I have to imput sport. I have 10 sports in the table and tried to add 11th one. WHat the hell should be double? Atributs are just about sports (name, id, names in different languages..)

MANY THANKS ALL!
Go to Top of Page
   

- Advertisement -