I am using developer 6.5. In one of the integrations I am not able to map from notification to the stored procedure input.
The notification variable is not able to pass the value to the stored procedure parameter. The stored procedure parameter gets null.
Basically the notification variable is not able to pass the value to the stored procedure parameter. I tried to save the notification variable in a temporary variable in the piepline and did print pipeline. It turns out that the temp variable has null value. But the notification variable has the value in it.
Why is the notification variable not able to map its value to another variable.
I have done this in many other scenraios and it has worked ok.
Do not know if something is specifically different with this particular notification. It is from oracle 9i to sybase stored proc.
Has anyone faced this?