Using the output of an Oracle Stored Function
Posted: Mon Sep 30, 2002 9:35 am
I need to use an oracle packaged function to get the value of a field to be used in a transform . The input to the transform is a sequential file and the output is an OCI8 stage.
The function will take 2 parameters (2 fields from the sequential file) and return a number which i need to populate a particular column in the output stage.
How can this be done? Can i use an OCI8 stage?
Any help is greatly appreciated.
The function will take 2 parameters (2 fields from the sequential file) and return a number which i need to populate a particular column in the output stage.
How can this be done? Can i use an OCI8 stage?
Any help is greatly appreciated.