Hi Experts,
I am using ODI 11g.
Currently i am using oracle procedures to call a function in ODI .
just like "Select package_name.function_name from dual " i am using this query in ODI variables.The output of the function
i am using in ODI mails .
So for this ..Suppose for any changes i need to go to the Oracle package and change the function logic...and then promote this
to production ..which is a time taking for me.
So i want to write this Function inside ODI variable and send the output to ODI mail ...So that i dont need DB side to promote
the code to production on every changes.
Please let me know whether this solution is good or not.
Thanks,
Lony