Skip to Main Content

Oracle Forms

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!

FRM-40654 Record Updated by another user

AdeelSep 7 2011 — edited Sep 14 2011
Hello Friends .. :)

I want to join to tables with connect prior query
I use this query and my result is ok ..
But when i try to use this query on form level
then I get this error ..

frm-40654: record updated by another user

Please tell me how to solve this problem..

Declare
msql long;
Begin

/*msql := ' (select * from time_attm a
where emp_ID = (select ID from personnel.personnel
where id = a.emp_id
connect by prior Id = mgr
start with id = ' || :global.id || '))';*/
set_block_property('time_attm', query_data_source_name,msql);
execute_query;
exception
When Others then
Message(Error_Code || ' : ' || Error_Text);
End;
This post has been answered by Amatu Allah Neveen Ebrahim on Sep 7 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2011
Added on Sep 7 2011
3 comments
855 views