I am using STP for calling a function that has two input parameters and a return code.
Input parameters are SP_KEY and SP_USER_ID. SP_KEY has values coming from the input link. SP_USER_ID has to take the Oracle user as the value. I cannot assign the Oracle User to this input parameter in the Stored Procedure because of the fact that it is called from a front-end application that passes values depending on the person modifying the data.
I tried using the stage variables and the Parameter marker/literal in the STP stage. But in both cases, I am getting a string as 'user' in the data
![Smile :)](./images/smilies/icon_smile.gif)
Would somebody give me a clue to proceed on this?
Thanks in advance,
Kusuma