An error occurs when you run a stored procedure on a MYSQL client with SAS/ACCESS^® Interface to MySQL, even though stored procedures are allowed in MySQL 5.0 or later. The following message is generated by this error:

ERROR: Execute error: PROCEDURE <stored procedure name>
can't return a result set in the given context

Even though the stored procedure is run on MySQL, the error occurs in the SAS^® System when results are returned from MySQL to SAS.

Select the Hot Fix tab in this note to access the hot fix for this issue.

After you install the hot fix, you can run stored procedures without encountering an error. However, you need to use the RESULTS=MEMORY option in the SQL procedure’s CONNECT statement, as follows:

Stored procedures are not supported when the RESULTS=SERVER or RESULTS=DISK options are used because these options do not bring in multiple result sets.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: