SQL & PL/SQL

Error at line 1
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 124
ORA-06512: at "SYS.DBMS_SCHEDULER", line 271
ORA-06512: at line 3

begin
DBMS_SCHEDULER.CREATE_JOB
        (
           job_name        => 'drop_acq_txn_1'
          ,start_date      =>  sysdate---TO_TIMESTAMP_TZ(to_char(sysdate+1/1200 ,'yyyy/mm/dd hh24:mi:ss')|| '.000000 +05:30','yyyy/mm/dd hh24:mi:ss.ff tzh:tzm')
          ,repeat_interval => 'FREQ=DAILY; INTERVAL=1'
          ,end_date        => NULL
          ,job_class       => 'DEFAULT_JOB_CLASS'
          ,job_type        => 'STORED_PROCEDURE'
          ,job_action      => 'PRC_DROP_ACQ_TXN(''-7-jan-2012'')'
          ,enabled         =>  TRUE
        );   
end;

Edited by: user8731258 on Jun 19, 2012 3:17 AM