Implementing SQL Proc in Outsystem

Implementing SQL Proc in Outsystem

  

Hi All,

For Outsystem I have a Input Paramert  'Ids' for My SQL Proc.


Name: Ids

DataType:Text

ExpandInline: Yes

Test Input: "1,2,3,9"

In Proc I have delcared this as Input Parameter as @IDs "VARCHAR(20)"

This @IDs Parameter is used in " IN Clause" Example: Select * from table in (@IDs)


When I do a test input Am getting Error as 'Sql or Proc contains more number of arguments'. How to resolve this error.

Hi Vetrivel,

Did you tested it seprately in any sql editor , is it working fine there ?

Please also see this link ..similar to your problem.

Sp Error

Regards

-PJ-