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

    Call a Concurrent Program from Oracle Alert




      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.