your database front-end

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.

SHOW CREATE PROCEDURE `mydatabase`.`%procedurename%`;


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

Solution

The solution is to:

  1. Ensure that the connection user has access to execute the specified procedure,
  2. Grant the connection user SELECT permission on the table mysql.proc

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. 

Content you want the user to see goes here.
close