Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC Sender Adapter ---Stored Procedure Call

Hello All

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 ?

Regards

Vinoad

Former Member
Not what you were looking for? View more on this topic or Ask a question