You must send the same message in multiple packages to several email addresses stored in the same
database table. How do you accomplish this by using a reusable package step? (Choose the best answer.)
A.
Create a procedure and add two tasks. The first one must have a Command on Source that reads the
email addresses from the database table and stores them in a bind variable, and the second must have a
Command on Target that uses OdiSendMail to send the email by using the bind variable defined in the
first task.
B.
Create a Knowledge Module. Add a task with a Command on Source that reads the email addresses from
the database table and stores them in a bind variable, and a Command on Target that uses OdiSendMail
to send the email using the bind variable defined in the Command on Source.
C.
Create a counter variable that gets the total number of email addresses stored in the database table. Next,create another variable that selects the email addresses from the database table. Then, create a loop in the
packages by using the variables and an OdiSendMail step.
D.
Create a procedure. Add a task with a Command on Source that reads the email addresses from the
database table and stores them in a bind variable, and a Command on Target that uses OdiSendMail to
send the email using the bind variable defined in the Command on Source.
Explanation:
(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/procedures.htm#ODIDG408)