Calling user-defined Oracle function
Posted: Mon May 14, 2007 2:28 pm
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.
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.