5 Replies Latest reply on Jan 23, 2017 10:37 AM by JamesH

    Call a Concurrent Program from Oracle Alert

    2888638

      All

       

      I have a requirement to call a concurrent program from an event based alert . I want to pass 2 dates in the form of varchar and 1number and 1 constant as parameters to the concurrent program .

       

      I have tried to pass the parameters like this :-

       

      &p_date_start &p_Date_end &p_person_id 'N'.

       

      But their values are not getting identified dynamically . Instead they are getting read as &p_date_start ....itself . Also , I cannot see the concurrent program being submitted anywhere as well .

       

      Any pointers in this regard would be of great help.

       

      Regards

      Abhilasha