Update Statement [message #581884] |
Thu, 11 April 2013 10:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/da1ddfe2e76671772a61dee2879db2d6?s=64&d=mm&r=g) |
inka
Messages: 14 Registered: February 2013
|
Junior Member |
|
|
Hello All,
I am using Apex 4.1 and Oracle 11g. I have a form with three fields and the report on it. One field is the select list. When I try to update a field I get this error:
ORA-00001: unique constraint (CFGMGR.DB_COMMENT_DB_COMMENT_ID_PK) violated
Here is the update statement:
begin
update DATABASE_COMMENT set
database_comment_desc = :P24_DATABASE_COMMENT_DESC,
create_date = :P24_CREATE_DATE,
database_comments_type = :P24_DATABASE_COMMENTS_TYPE,
UPDATE_DATE = :P24_UPDATE_DATE,
UPDATE_USERID = :P24_UPDATE_USERID
where database_id = :p24_database_id and
database_comment_id = :p24_database_comment_id;
commit;
end;
Any idea why I get this error?
|
|
|
Re: Update Statement [message #581932 is a reply to message #581884] |
Fri, 12 April 2013 00:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
3 fields on a form, but your UPDATE affects 5 columns?
Which column is a primary key column?
Why do you do it manually? Wouldn't you benefit from Apex automatic row processing which takes care about updates, inserts and deletes?
|
|
|