Home » Developer & Programmer » Application Express & MOD_PLSQL » Update Statement (Apex 4.1, Oracle 11g)
Update Statement [message #581884] Thu, 11 April 2013 10:27 Go to next message
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
Littlefoot
Messages: 19542
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?
Previous Topic: How to set-up OHS to connect to the DB(mod_plsql)
Next Topic: Conditional Button Display
Goto Forum:
  


Current Time: Wed Sep 03 02:36:30 CDT 2014

Total time taken to generate the page: 0.09402 seconds