i figured it out but i still have a question!

 

so i created a stored procedure within MySql which takes a parameter

 

something like this:

 

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetAllItems`(in p_Name varchar(50) )
BEGIN
SELECT *
FROM item
WHERE Name like p_Name;
END $$

 

 

Now when i try to connect via the database expert to my SP, it fails giving me an error like:

Query Engine Error: 'HY000:[MySql][....] Incorrect number of arguments for Procedure dbgeluid.GetAllItems; expected 1, got 0

 

so i tried via another way, using the Add Command functionality.

So i tried to add a new Sql Query typing:

call GetAllItems( {?sp_Name} )  

where sp_Name is a parameter i made in the "Parameter List".

When i try to apply this (by clicking "OK"), the system asks me for a discrete Value. I fill in a correct value and all is well...

 

So now the question:

 

Why can't i add the Stored procedure directly? Is this normal or am i doing something wrong?