Using AQ and event-driven scheduled job to execute DDL
I'm trying to use an event-driven scheduler job to execute DDL and DML. Everything works (trigger, message enque/dequeue, job run) except the actual SQL doesn't appear to execute or commit. Not sure what I'm missing. My job code is below. If I replace the dbms_sql calls with dbms_output.put_line, I can see that the SQL is being constructed correctly.
DECLARE
v_deqopt dbms_aq.dequeue_options_t;
v_prop dbms_aq.message_properties_t;
v_msgid raw(16);
v_msg ebs_obj_grant_type;
v_more_msgs boolean := true;
v_cnt number := 0;
v_cnt_max number := 1000;
v_sqltext varchar2(2000);
0