Hi John, You could use a scheduled job that queri...

2011-07-12T07:12:33.930-06:00

Hi John,

You could use a scheduled job that queries the apex_workspace_activity_log view every 5 minutes to email notifications about region errors. However if you want the information about the user's session state at that moment in time I think you'll need to keep the trigger.

Martin

Hi Martin, Would it not be a "safer" (i...

2011-07-12T01:40:19.461-06:00

Hi Martin,

Would it not be a "safer" (i.e. supported) option instead of creating a trigger like that, create a scheduled job (say every 5 minutes), that queries the apex_workspace_activity_log view (which is a valid apex dictionary view that it is supported to query), looping round the records created in the last 5 minutes and then performing the apex_util.submit_feedback, apex_mail.send etc?

Obviously this method would lose the immediacy of the trigger method you've outlined, but it wouldn't affect your core APEX installation and you would remain in a supported position.

John.

Comments on Martin Giffy D'Souza on Oracle APEX: APEX Region Errors - Part 3

Hi John, You could use a scheduled job that queri...

Hi Martin, Would it not be a "safer" (i...