117:
118: deq_options dbms_aq.dequeue_options_t;
119: deq_del_option dbms_aq.dequeue_options_t;
120: msg_props dbms_aq.message_properties_t;
121: bulk_obj system.ih_bulk_type;
122: l_dummy_payload system.ih_bulk_type;
123: l_dummy_msg_id RAW(16);
124: l_msg_id RAW(16);
125: num_rec NUMBER;
118: deq_options dbms_aq.dequeue_options_t;
119: deq_del_option dbms_aq.dequeue_options_t;
120: msg_props dbms_aq.message_properties_t;
121: bulk_obj system.ih_bulk_type;
122: l_dummy_payload system.ih_bulk_type;
123: l_dummy_msg_id RAW(16);
124: l_msg_id RAW(16);
125: num_rec NUMBER;
126: l_ret_status VARCHAR2(1);
140: l_time_max NUMBER; -- these two values need to be such that
141: l_time_min NUMBER := 100000; -- they are easily reset.
142: error NUMBER;
143: errm VARCHAR2(2000);
144: saved_bulk_obj system.IH_BULK_TYPE;
145:
146: aq_eof EXCEPTION;
147: pragma EXCEPTION_INIT (aq_eof, -25228);
148: