6 Replies Latest reply: Sep 14, 2012 10:47 PM by rp0428 RSS

    How to set an argument of BOOLEAN data type for DBMS_SCHEDULER.

    mennan
      Hi all;

      when i execute below statement it works correctly.
      BEGIN
        DBMS_SCHEDULER.define_program_argument(program_name      => 'JOB_FETCHER_PRG',
                                               argument_position => 1,
                                               argument_name     => 'DEBUGOPTION',
                                               argument_type     => 'PL/SQL BOOLEAN',
                                               default_value     => 'TRUE',
                                               out_argument      => FALSE);
      END;
      When i start job, it gives
      "ORA-06553: PLS-ORA-06553: PLS-306: wrong number or types of arguments in call to 'JOB_FETCHER'" error on all_scheduler_job_run_details view.

      Does anyone has any idea?I could not find any information about this.

      Regards...