Hi,
We have a requirement to call a user-defined Oracle function to do some logic. Hope we can call such user-defined function through an OCI stage.
Based on the return value of the user-defined function, we would need to route the record for further downstream processing. For example, if the function return 'Y', then we need to pass it on to one output link, else if the function returns 'N', then we have to pass those records to another link. Please let us know is this possible to accomplish.
Thanks.
Calling user-defined Oracle function
Moderators: chulett, rschirm, roy
Thanks Craig. So, you say that the function needs to be called from an SQL.
In our case, we would have to call a Oracle function somewhere in the middle of a Job and route the output based on the return value of the function. What could be the best possible solution for this? Is it that we would need to split the Job into two at the point where we need to call the function, so that we call call that function at the start of the second Job.
In our case, we would have to call a Oracle function somewhere in the middle of a Job and route the output based on the return value of the function. What could be the best possible solution for this? Is it that we would need to split the Job into two at the point where we need to call the function, so that we call call that function at the start of the second Job.