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.
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 user does not have access to the procedure then this process will raise an error.
The solution is to:
- Ensure that the connection user has access to execute the specified procedure,
- Grant the connection user SELECT permission on the table
Once that access has been granted to the procedure and the table
mysql.proc, then dbFront can retrieve the information it needs to correctly run the procedure.