Skip to Content

JDBC Receiver Adapter Stored Procedure multiple records at time

Hello Experts,

I have created scenario for synchronous Proxy to JDBC in which receiver JDBC calls stored procedure. In stored procedure, I am trying to insert multiple records at a time. I have referred following thread:

I am passing my input structure as XML.

When I test scenario, In PI log I get as Database request executed successfully. I don't get any error in PI. But its not updating/Calling ( Not sure ) stored procedure. In stored procedure response, I always get blank output ( Empty Payload ). It should return number of rows changed or exception raised as code for this is written in stored procedure.

Can you please help me with ,

1. Stored Procedure response parameter name I have given as 'return_value', Is there any specific name to be used ? Because my DB stored procedure developer says, there is no parameter name given for return value in stored procedure. So I have kept it as 'return_value' with type xsd:string.

2. Is there any way to confirm from PI that stored procedure is called and executed ? because always I get success message but nothing is happening in DB.

3. Can DB guys can get XML which they are receiving from SAP PI ?

Here, third party DB is SQL Server 2014.

Thanks and Regards,

Gaurav Khandelwal

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jul 18, 2016 at 11:48 PM

    Hi Gaurav,

    I had similar scenario where date formats were not correct and even though the call from PI was showing successful, nothing happened in DB. Try executing the stored proc using same data that you are using to test the stored procedure.

    Another thing to check would be to confirm that you have used right data types as per link below:

    Defining an EXECUTE Statement - Advanced Adapter Engine - SAP Library

    Regards,

    Sanjeev

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 19, 2016 at 01:20 PM

    Hello Everyone,

    Can you please help in above regards ?

    Thanks and Regards,

    Gaurav Khandelwal

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.