| Update Statement [message #581884] |
Thu, 11 April 2013 10:27  |
 |
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  |
 |
Littlefoot
Messages: 21823
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
