Hello .
I am trying to call store proc (oracle) which performs truncates based on input keys. One of the input key (p_measure) in store proc is declared as varchar. When passing the values to store proc in datastage, null value is getting passed for p_measure key. To debug, i am routing the values of input keys to dummy table inside store proc and i am seeing null value for p_measure.
When redirected the values to peek, iam seeing correct value.
I ran store proc in sql developer and it ran fine,no issues.
Any one faced this issue before ? Do i need to follow any convention for varchar variables passed to store proc ?
Thank you.
NULL getting passed to transformer.
Moderators: chulett, rschirm, roy