Bernie
Posts: 0
Joined: Fri Jul 27, 2012 2:06 pm

maximum arguments for API Express query/stored procedure?

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.

Galyna Abramovych
Site Admin
Posts: 84
Joined: Tue Mar 22, 2016 6:03 pm

maximum arguments for API Express query/stored procedure?

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?

Bernie
Posts: 0
Joined: Fri Jul 27, 2012 2:06 pm

maximum arguments for API Express query/stored procedure?

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. Image

Bernie
Posts: 0
Joined: Fri Jul 27, 2012 2:06 pm

maximum arguments for API Express query/stored procedure?

I double checked again and it might be that it is only missing the counterpart of that additional parameter in the stored procedure.

Serhii Kulibaba
Posts: 150
Joined: Tue Aug 27, 2013 1:47 pm

maximum arguments for API Express query/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...

Return to “Issues”