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!

Refresh the data block with the existing data w/o Execute Query.

FormsApr 10 2008 — edited Apr 26 2008
Hi All,

I do have a block. I am giving the user to do manipulations based on Enter Query, where they restrict the data block to some data and perform some manipulation.

I have a Save Button in Which I perform Commit_form and also Call one procedure.
The procedure, tries to update the records on the table, which is currentlu on the block. After this when I try to update the data which got updated by the procedure, it says that the data is updated by another user. Requery.

Now I can see the refreshed data by giving execute query after the procedure call. But it brings me all the records in the table. But I need to see the refreshed records which was selected by the user's Enter query. Is there any way to achieve it?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 24 2008
Added on Apr 10 2008
6 comments
6,909 views