7 Replies Latest reply on Jul 2, 2014 9:47 AM by GregV

    ORA-24155 with define_chain_rule

    Matze1969

      Dear all,

       

      I try to set up a scheduler chain. Unfortunately I get the following error. I'm executing the following code (excerpt):

       

      sys.dbms_scheduler.create_chain(...);

      sys.dbms_scheduler.define_chain_step(...);

      ...

      sys.dbms_scheduler.define_chain_step(...):

       

      The following fails:

       

        sys.dbms_scheduler.define_chain_rule(

                                              chain_name    => 'IDIS_INFRA.INFRA_STAGE'

                                            , condition     => '"STG_BS_LAGE" FAILED'

                                            , action        => 'END '

                                            , rule_name     => 'IDIS_INFRA.END_BS_LAGE'

                                            , comments      => null

        );

       

      Database version is 11.2 (no patch).

       

      On my local database (also 11.2 no patch) and on Oracle XE 11g I can create the chain rule without error.

       

      What could be the reason?

       

      Kind reegards

      Matthias