Is there a maximum of arguments for a API Express query/stored procedure?
I get this error message when I use more than 6 parameters
code: AE009
message: Procedure or function 123 has too many arguments specified.
Is there a maximum of arguments for a API Express query/stored procedure?
I get this error message when I use more than 6 parameters
code: AE009
message: Procedure or function 123 has too many arguments specified.
Hello Bernie,
Appery.io does not set any restrictions in this respect.
So, we need to troubleshoot this issue in more details.
Could you provide the type of database (MySQL, mssql, Oracle or Postrgresql) and its version? Also, could you provide the code of your procedure or at least the signature and specify the place (editor or runtime) where this error occurred?
Hi Galyna,
This was recognized on SQL Server hosted on Azure when executing a stored procedure.
This query works:
EXECUTE MWSAB_Vessels_BBox16 @minX= :min4X, @minY= :min4Y, @maxX= :max4X, @maxY= :max4Y, @parval= :parval, @qtype= :qtype
If I add another parameter to it, I get the error message from the screen shot.
I double checked again and it might be that it is only missing the counterpart of that additional parameter in the stored procedure.
The Stored procedure works with 10, 20 and more arguments - just checked it.
It seems the signature of your stored procedure doesn't match with it's call. Here is the similar issue:
https://stackoverflow.com/questions/1...