DBMS_Scheduler example

dbms_scheduler.sql

    job_name := dbms_scheduler.generate_job_name(prefix => 'Bilagr_');

    dbms_scheduler.create_job (
      job_name            =>  job_name,
      job_type            =>  'STORED_PROCEDURE',
      job_action          =>  'Bilagr.Run',
      start_date          =>  Sysdate,
      enabled             =>  true,
      auto_drop           =>  true,
      number_of_arguments => 2
    );

    dbms_scheduler.set_job_argument_value(
      job_name          => job_name,
      argument_position => 1,
      argument_value    => :new.bill_run_no
    );

    dbms_scheduler.set_job_argument_value(
      job_name          => job_name,
      argument_position => 2,
      argument_value    => 'bilagr'
    );

-- but, this shit commits :/