This discussion is archived
6 Replies Latest reply: Sep 14, 2012 8:47 PM by rp0428 RSS

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

mennan Newbie
Currently Being Moderated
Hi all;

when i execute below statement it works correctly.
  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);
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.