Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-27486: insufficient privileges ORA-06512: at "SYS.DBMS_ISCHED", line 12

user8731258Jun 19 2012 — edited Jun 19 2012
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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 17 2012
Added on Jun 19 2012
#11g
11 comments
85,607 views