Search notes:

Task wrapper script: _exec-stmt.sql

_exec-stmt.sql is a wrapper script to execute a PL/SQL statement as a task.

begin
   task_mgmt.begin_(q'{&1}');
   &1;
   task_mgmt.done;
exception when others then
   dbms_output.put_line(q'{ERROR executing &1}');
   dbms_output.put_line('  ' || sqlerrm);
   task_mgmt.exc;
end;
/

Github repository PL-SQL-pkg-task, path: /_exec-stmt.sql

Index