Adsense Ad

Monday, 12 February 2018

Oracle Forms: Progress Bar Solution - 2

One option you could use is to create a displayed, non-base table, text item in the form. Then in your when-button-pressed trigger, you can assign values like: "Step 1", "Step 2" etc. to this displayed field in your procedure in between each of the calls. You will also need to use the "Synchronize" command after you assign each value and before you call the next step.

For example, if your when-button-pressed trigger now is something like this:
begin
procedure_1;
procedure_2;
procedure_3;
-- (etc.)
end;

Create a displayed, but non-enterable field named: show_progress, then change your trigger to:
begin
:show_progress := 'Step 1';
synchronize;
procedure_1;
:show_progress := 'Step 2';
synchronize;
procedure_2;
:show_progress := 'Step 3';
synchronize;
procedure_3;
-- (etc.)
end;

No comments: