Using stored procedures that take parameters

[Former Member]

I'm trying to invoke (MSSQL) stored procedures from Visual Composer. I've got the tool to see the procedures, but when the data service definition is created, there are no inputs, even though the procedures take parameters. When I run the Test Data Service wizard and press execute, I get an error saying a parameter wasn't provided. The input area on the left of the wizard window shows no input parameters and if I click the add button, I get nothing.

Am I doing something wrong?

Thanks.

[Former Member]

The problem was the data type. I declared the input parameter to be of type CHAR but VC wants unicode, so I changed the type to NCHAR and it works.

[Former Member]

Hi

I think you should check the stored procedure. If the stored procedure defines the input parameters correctly or not.

Regards

Inder