Hi, I have a simple store procedure created. but when i try to run it. Its throwing an error:
Failed [5531 : HY000] Named-list is not supported for arguments of a procedure
Satetment 1: Unknown failed.
Here is the store procedure:
create procedure "retail".testCount(out cnt integer)
select 10 into cnt;
The procedure is being created, but not run correctly. Any help really appreciated!
call procedure "retails".testCount();
But then after some reseach I read that we need to pass a dummy variable, so I changed to
call procedure "retails".testCount(dumm); -> this worked! Thanks Fred!