OK so I have created a timer as below, timer starts as expected :) we have a long running process that runs in the background as a scheduled job and updates a context to show progress (get_progress_bar is a function that returns an HTML page with stats/progress on the job) now I can see that the v_progress variable gets to 100 and the code executes the end_progress_timer with no errors.... but the timer continues to expire .... how do you stop a timer??? :)

procedure start_progress_timer is

begin

api_timer.startTimer('progress_timer');

end;

procedure end_progress_timer is

begin

api_timer.stopTimer('progress_timer');

end;

procedure progress_timer_expired is

v_clob clob;

v_progress number;

begin

v_clob := get_progress_bar;

api_component.setvalue('progress.generatedemandprogress',v_clob);

select sys_context('generate_dp_progress_ctx','PROGRESS') into v_progress from dual;

if (v_progress = 100) then

end_progress_timer;

end if;

end;

asked 05 Feb '16, 06:32

apacheuk's gravatar image

apacheuk
1391223
accept rate: 0%


We already talked about this with Simon via an email exchange but for readers of this thread, this seems to be a bug.

Yalim

link

answered 12 Feb '16, 03:17

Yalim's gravatar image

Yalim ♦♦
2.8k5
accept rate: 21%

patch has been applied and has fixed the issue

Cheers

link

answered 17 Feb '16, 05:28

apacheuk's gravatar image

apacheuk
1391223
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×10
×1

Asked: 05 Feb '16, 06:32

Seen: 1,452 times

Last updated: 17 Feb '16, 05:28


© Copyright Gerger 2017