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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Refresh block

863006Jun 26 2012 — edited Jun 28 2012
Hi all,
I'm using Oracle Forms Builder 10GR2. I have a database block and a procedure which just updates the values of some fields in that DB block. The problem is that the new values don't appear immediately even i have specified commit in the procedure. I have to requery the database block to see the new values. Any ideas how this can be achieved? Also, i tried to specify an INTO clause for those fields but i think this is not working because of their database item property...

In other block, which is not database, i have something like this :
select <value> INTO :<field> FROM <table_name>
and the value of that field is automatically refreshed. Is this going to work for db items? If yes, why i'm not able to compile my procedure when the syntax is the same as the non-db items? The error is : Bad bind variable....



Thanks in advance,
Bahchevanov.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 26 2012
Added on Jun 26 2012
12 comments
4,583 views