Can Alert Inputs Be Any More Flexible?
I have a brain teaser for the Community: Can anyone tell me if there is a way to pass multiple values into an Alert Input? E.g, I want my Select Statement to look something like " SELECT 'true' INTO &OUTPUT1 FROM dual where 1 in (:test_vals) " and to return the single record containing "true" when test_vals contains "1". The real-world goal includes including or excluding sets of operating units without needing to create dedicated Alert Actions when the email to be generated is exactly the same and can be dynamically directed to appropriate individuals. Consider how two B2B OUs