[Home] [Help]
3951: wf_items
3952: where
3953: wf_item_activity_statuses.item_type = workflowItemType and
3954: wf_item_activity_statuses.activity_status = 'ERROR' and
3955: wf_item_activity_statuses.error_stack like (wf_core.newline || 'AME_%') and
3956: wf_item_activity_statuses.item_type = wf_items.item_type and
3957: wf_item_activity_statuses.item_key = wf_items.item_key and
3958: wf_items.end_date is null;
3959: else
3969: where
3970: wf_item_activity_statuses.item_type = workflowItemType and
3971: wf_item_activity_statuses.item_key = workflowItemKey and
3972: wf_item_activity_statuses.activity_status = 'ERROR' and
3973: wf_item_activity_statuses.error_stack like (wf_core.newline || 'AME_%') and
3974: wf_item_activity_statuses.item_type = wf_items.item_type and
3975: wf_item_activity_statuses.item_key = wf_items.item_key and
3976: wf_items.end_date is null;
3977: end if;
3980: fetch logCursor into logCursorValues;
3981: exit when logCursor%notfound;
3982: /*
3983: This code assumes that the error_stack is a sequence of entries of the form
3984: wf_core.newline || [package].[routine]([logId])
3985: which in aggregate look like a call stack (but we don't include a real
3986: argument list between the parentheses, just our log ID). See ame_util.runtimeException
3987: for the code that generates these entries.
3988: */
3989: errorStackLength := lengthb(logCursorValues.error_stack);
3990: currentCallRightParen := 1;
3991: loop
3992: currentCallStart := instrb(logCursorValues.error_stack,
3993: wf_core.newline,
3994: currentCallRightParen,
3995: 1) + 1;
3996: if(currentCallStart = 0) then
3997: exit;