ORA-00001: Unique constraint (OWNER.CONSTRAINT_NAME) violated

Hi all guru's, i got a doubt that cant be answered here... i need to update a table in a procedure but unexpectedly it cant be done... hre are the code:

[code]
cursor c14 is
select  a.contact_name, b.scr_name v_name, b.emplid
from PS_TEST a, PS_TAKE b where b.emplid = a.emplid
for update of a.contact_name;  

--------------------------------------------
        for rec in c014 loop
                         
        select scr_last_name v_mname1, scr_middle_name v_lname1, scr_first_name v_fname1
        , (scr_first_name ||' '||scr_last_name||' '||scr_middle_name) v_name1
        into v_mname1, v_lname1, v_fname1, v_name1
        from PS_TAKE sample(1) where rownum = 1 ;
       
      update
      PS_TEST 
        set contact_name = v_name1
        --where contact_name = rec.contact_name;
        where current of c014;
      exit when c014%notfound;       
      end loop;

[/code]

Above are the cursor and the code that related. This code cant be done in procedure, it ill show this error :

[code]
ERROR at line 1:
ORA-00001: unique constraint (SYSADM.PS_TEST) violated
ORA-06512: at "SHAHRIL.UPDATE_ALL_DEPENDENTS", line 572
ORA-06512: at line 1

[/code]

Kindly need all of your sggestion and opinion on this. An advance, really appreciate on it.

Thanks

Hi all guru's, i got a doubt that cant be answered here... i need to update a table in a procedure but unexpectedly it cant be done... hre are the code:

[code]
cursor c14 is
select  a.contact_name, b.scr_name v_name, b.emplid
from PS_TEST a, PS_TAKE b where b.emplid = a.emplid
for update of a.contact_name;  

--------------------------------------------
        for rec in c014 loop
                         
        select scr_last_name v_mname1, scr_middle_name v_lname1, scr_first_name v_fname1
        , (scr_first_name ||' '||scr_last_name||' '||scr_middle_name) v_name1
        into v_mname1, v_lname1, v_fname1, v_name1
        from PS_TAKE sample(1) where rownum = 1 ;
       
      update
      PS_TEST 
        set contact_name = v_name1
        --where contact_name = rec.contact_name;
        where current of c014;
      exit when c014%notfound;       
      end loop;

[/code]

Above are the cursor and the code that related. This code cant be done in procedure, it ill show this error :

[code]
ERROR at line 1:
ORA-00001: unique constraint (SYSADM.PS_TEST) violated
ORA-06512: at "SHAHRIL.UPDATE_ALL_DEPENDENTS", line 572
ORA-06512: at line 1

[/code]

Kindly need all of your sggestion and opinion on this. An advance, really appreciate on it.

Thanks

hello ORA-00001: Unique constraint (OWNER.CONSTRAINT_NAME) violated, this is the error occuring while am trying to insert the records into the table could u please provide a solution for this error

Hello, I hope someone can help with this -

We have a table that has a unique key on one of the columns, but that column is also allowed to be null. The intent of this was that any number of records could be null in that column, but any records that DID have values should all have unique values for that column. This is exactly how a unique key is supposed to work, as I understand it.

This has been working perfectly fine for years and has not been changed at all. However, recently our database has begun to throw this error when a stored procedure tries to insert a record that would have null in that column, and I can't figure out why.

Sample table and constraint scripts (names altered and extra stuff dropped to protect the innocent ^_^):

create table ABC.ITEM_MASTER

(  item_id   number(8),

   item_name   varchar2(12),

   bucket_code   varchar2(4)

);

create unique index ABC.ITEM_MASTER_UC1 on ABC.ITEM_MASTER (bucket_code);

Stored proc code that is causing the error:

insert into ABC.ITEM_MASTER (item_id, item_name) values (123,'A');

Error message:

ORA-00001: unique constraint (ABC.ITEM_MASTER_UC1) violated

...Help, please?