I have a unconnected stored procedure(for doing updates to a table) in my mapping it should be run after the session is complete. so i set its order to Post-Target load. but the problem is the stored procedure has a port RETURN_VALUE and i am not returning anything from my stored procedure.
I only do updates inside my stored procedure.
i tried to call the stored procedure from an expression transformation but since this procedure has no input parameters i cannot call it from an expression transformation. how do i handle the return_value port for Post-load procedure in my mapping ?
I only do updates inside my stored procedure.
i tried to call the stored procedure from an expression transformation but since this procedure has no input parameters i cannot call it from an expression transformation. how do i handle the return_value port for Post-load procedure in my mapping ?