Running a SmartConnect map using the SQL Stored Procedure Destination. Receiving an error that says ‘The selected stored procedure does not meet the requirements. Please see more details.’ The detail section says:
The stored procedure requires both of the following out parameters:
1. varchar(255)
2. int.
For a stored procedure to be used by SmartConnect it must have at least two output
parameters, and integer and a varchar.
The first integer output parameter is checked to determine the success of the call. If the integer
is 0 the process is considered successful. Anything else and the process is considered to have
failed.
The first varchar output parameter is checked to determine any error messages. This message will be displayed to the SmartConnect user if the stored procedure is deemed to have failed.
Note: if this is an eConnect type store procedure with the validation messages stored in the eConnect tables this parameter should return the number of the eConnect message to be displayed as a varchar.
