How to capture response from store procedure in connect sql save method.
Hi All,
We are having a problem to capture response from the store procedure when we used RDB-Save method in connect sql.When we run the store procedure from DB side we can see there is a response field.
So to capture this we have tried to use out keyword.Please see below query that we are using.
\{call SPName ({.DataRequestFields.guContactKeyID}, {.DataRequestFields.cvAlertCategory}, {.DataRequestFields.cvAlertPriority}, {.DataRequestFields.cvAlertStatus}, {.DataRequestFields.cvAlertText}, {.DataRequestFields.cvCreateUser} {.pyNote out}) \}
We are getting below error after executing this.
Incorrect syntax near '@P6'. DatabaseException caused by prior exception:
Can anyone eplan how can we use this out keyword in RDB-Save method please.
Thanks,
LahiruK