I have a defined Oracle function. This function returns "1" or "0" depending on some internal logic.
I can capture the function's output to a variable when i execute it directly as a stored procedure, but what i really need is Control-M notify me by email ONLY when the output of the function is "1".
I've checked the output of the variable by shouting it/mailing it, so it is working OK.
Summarizing: When output function is 1, then mail, when 0, do nothing.
How can I do this?
Any help would be appreciated.