APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Make a primary key field in a tabular form editable

JJINSep 25 2009 — edited Sep 28 2009

Hi,

I have created a tabular form based on a table(User_details) in which i give user_id(varchar2(30)) as a primary key. In

the tabular form it is not editable.How can i make it editable. When i tried to make it editable by changing the "display

as " option to "text field"and when i press the submit button after some modification it is giving error"
{code}

Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-20001: Current version of data in

database has changed since user initiated update process. current checksum

= "AECC46D93280EA8D4B4194DC0DEA64DA", item checksum = "D5F18BAD9ADAB2D18A53F82C8346A426".,

update "TEST_SCHEMA"."USER_DETAILS" set "USER_ID" = :b1, "USER_GROUP_ID" = :b2

{code}
How can i make a primary key field editable with out causing errors,

Thanks,
TJ

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 26 2009

Added on Sep 25 2009

#apex-discussions

14 comments

1,908 views