35: l_commit VARCHAR2(3) := 'T';
36:
37: --Select the retry count from events table
38: Cursor retry_cur(p_msgid IN RAW) is
39: select /*+ INDEX (OKC_AQ_EV_TAB) */ retry_count
40: from OKC_AQ_EV_TAB
41: where msgid = p_msgid;
42:
43: BEGIN
36:
37: --Select the retry count from events table
38: Cursor retry_cur(p_msgid IN RAW) is
39: select /*+ INDEX (OKC_AQ_EV_TAB) */ retry_count
40: from OKC_AQ_EV_TAB
41: where msgid = p_msgid;
42:
43: BEGIN
44: --Initialize return status