Article Content
Article Number | 000035509 |
Applies To | RSA Product Set: RSA Identity Governance and Lifecycle RSA Version/Condition: All |
Issue | If you have an AFX Database Connector, you expect its capability to be able to call a Stored Procedure with IN and OUT parameter(s) but it is not working because the Stored Procedure OUT parameter is not supported by RSA Identity Governance and Lifecycle's AFX Database Connectors (MySQL, MS SQL, etc.). When the AFX Database Connector capability executes a Stored Procedure with the OUT parameter (@out_param) in the query field the following error displays:
When AFX Database Connector capability executes a Stored Procedure with the OUT parameter (@out_param) in the query field, it expects declaring the output variable, but when you include the declaration, it shows the following error:
|
Cause | Currently, RSA Identity Governance and Lifecycle's AFX Database Connector does not support calling Stored Procedures with OUT parameters. The product supports calling Stored Procedures with IN parameters only from an AFX Database Connector. |
Workaround | As a workaround:
The workaround is documented on page 36 of the RSA Identity Governance and Lifecycle - MySQL Application Guide. The RSA Identity Governance and Lifecycle AFX Database Connector supports calling a Stored Procedure with IN parameters only.
A request for enhancement (ACM-75945) has been raised to accommodate this request. |