Toad World® Forums

Sybase Database Error: Invalid amount of parameters ?


#1

When I try to execute a stored procedure with parameters I get the following error : Lookup Error - Sybase Database Error: Invalid amount of parameters.

exec web_get_top5_bd_sauv works fine

but exec web_get_top5_bd_sauv @outputmode=“print” does not.

toad_002.sql (5.49 KB)


#2

Unfortunately there seems to be an issue on our side with named parameters. While I investigate is it possible for you to run the procedure without the parameter name? For example, “exec web_get_top5_bd_sauv ‘print’”.

Thanks.


#3

As it turns out this is another issue with the Sybase ADO.Net driver. Sybase has technical support case 11647711 for this issue.


#4

Using named parameters now works with the latest beta realease (1.0.0.368).


#5

Glad to hear it, let me know if you come across any other issues.

Thanks.