Database Administration (MOSC)

MOSC Banner

Using AQ and event-driven scheduled job to execute DDL

edited Feb 5, 2017 10:28AM in Database Administration (MOSC) 3 commentsAnswered ✓
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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center