Passing Integer value as Parameters in a Stored Procedure

[former_member762739]

Hi all,

From SAP BODS script i am calling a Stored Procedure where with 5 parameters. Out of Which 1 parameter is Int Type. I have stored these values in a Global Variables and the Int type is declared as 'INT'. But while calling the SP i can see in the log the Integer value is being passed as wrapped around '', my concern is will this be considered as String when it will hit the back end DB where the SP is written. I don't have write access to Back end DB so not able to execute it directly. Please find the below attached screenshot

as you can see 2 is wrapped around ''. so i tried to replace_substr before hand .

even after this i am getting the same . can some one tell me if this will be an issue?

or what would be the right approach to call the SP with parameters that are stored in Global Variables and one of them is Integer type. Below is the calling of Stored Proc from BODS end