MySQL: Can't load [%procedurename%] parameters

When setting up or running a MySQL stored procedure, you may see the following errors:

• Can't load [%procedurename%] parameters
• Data is Null.
• This method or property cannot be called on Null values.

Issue

dbFront queries the MySql server for the stored procedure parameters before execution and at the point of configuration.

If the procedure name is not found, or if the database connection does not have access to the procedure, then this process will raise an error.

Solution

The solution is to:

• Ensure that the database connection has access to execute the specified procedure,
• Grant the database connection user SELECT permission on the table mysql.proc,
• NOTE: The database connection user refers only to the database user that was used when creating the connection from dbFront to your database.  This user should not be confused with the user that is logged in to dbFront.  The user connected to dbFront is likely to have ZERO direct access to your database.

Once that access has been granted to the procedure and the table mysql.proc, then dbFront can retrieve the information it needs to run the procedure correctly.