The OCI stage only uses SQL. So, if you can specify how you'd use it in SQL, you can use it in the OCI stage. Presumably as a "before" command rather than every row.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
It's a procedure, so you'd need to call it directly in the Before (or After) SQL tab. Search the forum for examples of using Stored Procedures with the OCI stages.
-craig
"You can never have too many knives" -- Logan Nine Fingers
If CALL doesn't work try execute, but for some reason I think datastage likes call better. I tried looking for an example of how we do this but couldn't find one.