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!

go_block doesn't wait after execute query.

586954Jul 16 2007 — edited Jul 17 2007
Hi All,

I have an issue with go_block and execute query sequence. I have a code
snippet which is in a program unit called form key-exeqry trigger. As per
the expected behaviour the cursor should wait on the block for user input.
But it just shows the block with the details and moves to the next code
after execute-query. I added few debug messages in when-new-block-instance
and pre-query triggers for the block, but none of them get executed.

This block is being displayed through an another flow and there it waits .
Please help!!

Thanks in advance
Ashok

if l_cnt >0 then
message('condition matched');pause;
l_where := 'acct_no = 1114';
go_block('sel_acct');
clear_block(no_validate);
set_block_property('sel_acct',DEFAULT_WHERE,l_where);
execute_query;
message('after sel_acct');pause;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2007
Added on Jul 16 2007
5 comments
810 views