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
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:

database_comment_desc = :P24_DATABASE_COMMENT_DESC,
create_date = :P24_CREATE_DATE,
database_comments_type = :P24_DATABASE_COMMENTS_TYPE,
where database_id = :p24_database_id and
database_comment_id = :p24_database_comment_id;


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
Messages: 20493
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: Thu Nov 26 01:23:15 CST 2015

Total time taken to generate the page: 0.07886 seconds