Skip to Content
avatar image
Former Member

Proxy to JDBC Scenario using Stored Procedure with SQL Server

Hi,

My Scenario is ABAP Proxy -> PI -> JDBC receiver(Stored Procedure). My scenario is working fine when I go and check in Communication Channel Monitoring. The messages are successful. But the records are not updated in SQL Server.  Where could be the problem.

Regards

Srinivas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 13, 2013 at 08:39 AM

    Hi,

    try to set the logging on the SQL server and you will see what you're trying to execute - probably wrong parameters which may not do anything,

    Regards,

    Michal Krawczyk

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 13, 2013 at 10:27 AM

    Hi Srnivas,

    Check with the DB team that the stored procedure makes a commit whether the process is succesful. To start, i would call the stored procedure directly with a SQL IDE.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Thank you for your responses. The problem which I mentioned in the above discussion was solved. But I have a doubt. Can I use multiple staging table names in a stored procedure.

      Responses will be highly appreciated.

      Regards.

  • avatar image
    Former Member
    Aug 13, 2013 at 10:43 AM

    Hi,

    Thank you for your responses. The above given problem was solved. I was not sending the correct data where one field was nvarchar. The above problem is solved.

    In the same scenario, Can I have four staging tables for four nodes in a stored procedure and in the "table" value can I give a table values for each node. If possible how can I give the target structure.

    Responses are highly appreciated.

    Regards,

    Srinivas

    Add comment
    10|10000 characters needed characters exceeded