Skip to Main Content

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!

Unable to create chains using scheduler

ManikMay 22 2012 — edited May 22 2012
Hi,

In Oracle 11g r2
CREATE OR REPLACE PROCEDURE p_tst
AS
BEGIN
   DBMS_SCHEDULER.CREATE_CHAIN (chain_name            => 'CHAIN_DELTA1',
                                rule_set_name         => NULL,
                                evaluation_interval   => NULL,
                                comments              => NULL);
END;
--=================================
EXEC p_tst;
I am facing the error. ORA-01031: insufficient privileges.
I have DBA role assigned to my userid. what might be the reason for the error?

Regards,
Manikya.
This post has been answered by Stew Ashton on May 22 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2012
Added on May 22 2012
3 comments
518 views