JDBC Sender Adapter ---Stored Procedure Call
I have a scenario JDBC--> PO 7.4 --->Proxy. We are using SAP PO 7.4 single stack SP 11.
To fetch the data from the SQL database , in sender JDBC adapter we are using the stored procedure ( as we are fetching the data from multiple tables ). I am passing the parameters to the stored procedure in the quesry SQL statement as :
SAPsp_FetchData @ Area= 'XYZ' , @FromDate = '20150801',@Todate = '20150831'
The stored procedure ' SAPsp_FetchData' works fine with this statement BUT the issue is that I cannot pass the hardcoded value for @Area,@FromDate,@Todate. I want to know is there an option to pass the values for these parameters dynamically to fetch the data from the database ?