SQL Executor and SQL creator result varies for Stored Procedure query

I have a SQL stored procedure to get asset details with input of two List Values (Exec get asset details 'L1,L2'.where L1 and L2 contains concatenated values like L1=100,101,... and L2 = 1001,1002...) When I use SQL creator I am getting the correct results as similar to MS SQL Server Management studio.(But I used hard coded List Values ) and outputs asset details along with L1,L2 values but I am not able to pass the List values in the same workspace for SQL creator as list values derived from the another system using Http Caller.However these same List values used in SQL Executor in the same workspace runs outputs asset details along with only L1 values but not with L2 values. Please suggest me.