Skip to Content

Calling the stored Procedure through SAP BODS

Hi All,

i am calling stored procedure through sap bods

EXEC Rep.dbo.CARES_Redemption
@argPromotions='1635,1757,1787';

i am getting below the error. Can you please let us know how to fix the Issue.

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1,
current count = 0.>.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 17 at 04:19 PM

    Hi Kris

    If the same statement is executed direclty on the DBMS whats the outcome

    Regards

    Charles

    Add comment
    10|10000 characters needed characters exceeded

  • May 23 at 01:14 PM

    Hi kris k,

    Have you applied escape characters in the script for the below stored procedure

    EXEC Rep.dbo.CARES_Redemption @argPromotions='1635,1757,1787';
    
    ##SAP Data Services Script: 
    sql(DataStoreName,'EXEC Rep.dbo.CARES_Redemption @argPromotions=\'1635,1757,1787\';');

    I suggest you to please execute the above stored procedure in the database before calling directly in the SAP Data Services.

    Thanks & Regards,
    Akhilesh Kiran N.

    Add comment
    10|10000 characters needed characters exceeded